========================================================================= Date: Mon, 1 Mar 1993 11:53:35 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: S-DESJ@UMINN1.BITNET Subject: NO SUBJECT Please subscribe my i.d. to your list about access information. Thanks ========================================================================= Date: Mon, 1 Mar 1993 13:32:00 EDT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Phil Comeau Subject: Re: Tab move sequence in Form. In-Reply-To: ; from "Undetermined origin c/o Postmaster" at Feb 26, 93 4:32 pm > So, are other people coming to the conclusion that MS Access is a hodged > together POS like I am? Hard to say. Perhaps if you let us know what kind of hodged together POS you are, we could make a valid comparison. Sorry. Couldn't resist. Phil Comeau, Software Kinetics Ltd. comeau@crc.sofkin.ca ========================================================================= Date: Mon, 1 Mar 1993 13:35:04 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "NATHAN BRINDLE" Subject: Re: NO SUBJECT In-Reply-To: Message of Mon, 1 Mar 1993 11:53:35 -0500 from I would be glad to do so, but I need a name to go with the user id to make Listserv happy. :) You can subscribe yourself, if you wish, by sending a message to LISTSERV@INDYCMS.BITNET with the single line SUBSCRIBE S-DESJ@UMINN Your Name Either way is fine; like I say, I just need a real name to go with the id. Thanks, -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 1 Mar 1993 13:50:14 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "NATHAN BRINDLE" Subject: apology Sorry about that last message--I didn't look closely enough at the header and replied to the list. It's Monday... -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 1 Mar 1993 14:00:52 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: GA4161@SIUCVMB.BITNET Subject: DDE manipulation of Access Can anyone tell me how to open an Access database via the DDE interface described in the Access readme file? At present I can retrieve data from such a database (if I know the names of the tables within it) with DDE values like the following: Topic:utility;sql select * from employees in nwind.mdb; Item: all , or data, or ... as required. Thanks in advance! Elizabeth Klaver ga4161@siucvmb.siu.edu Dept. of English Southern Illinois University, Carbondale ========================================================================= Date: Mon, 1 Mar 1993 17:58:38 -0800 Reply-To: robert@slipknot.rain.com Sender: "Microsoft Access Database Discussion List" From: robert@SLIPKNOT.RAIN.COM Subject: printing reports (macro limitations) Does anyone know if there is any way for me to write a macro that will print a report to a file? In my effort to produce an ASCII input file as a report from Access, I've gotten to the point where I can produce the report and manually print it to a file using a generic driver to generate ASCII (non-Postscript) data, suitable for input to the next stage of my processing pipeline. However, when I try to automate this by putting it into a macro, I can find no way to get past the print Dialog box. I need to use it rather than the Print Action because the latter specifies no parameters for enabling "print to file." I tried the SendKeys? Action to send %l (ALT-l) and a file name, but Access just sat there with the Print Dialog box, and would get no further. Any ideas? ________________________________________________________________________________ Robert Reed Home Animation Ltd. 503-656-8414 robert@slipknot.rain.com 5686 First Court, West Linn, OR 97068 I went to a museum where they have all the heads and arms of the statues in the other museums --Steve Wright ________________________________________________________________________________ ========================================================================= Date: Tue, 2 Mar 1993 07:15:35 PDT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Mark Barnet (Business Enter. Syst. Tech)" Subject: RE: printing reports (macro limitations) If I use the Setup from the report, and specify the generic printer driver assigned to FILE: then all I get when I run the report is a dialog box asking for the filename. It sounds like you are getting more than that. Possibly because you have the generic printer driver assigned to LPT1: rather than to FILE:. ---------- |From: |To: Multiple recipients of list ACCESS-L |Subject: printing reports (macro limitations) |Date: Monday, March 01, 1993 5:58PM | |Does anyone know if there is any way for me to write a macro that will print a |report to a file? | |In my effort to produce an ASCII input file as a report from Access, I've |gotten to the point where I can produce the report and manually print it to a |file using a generic driver to generate ASCII (non-Postscript) data, suitable |for input to the next stage of my processing pipeline. However, when I try to |automate this by putting it into a macro, I can find no way to get past the |print Dialog box. I need to use it rather than the Print Action because the |latter specifies no parameters for enabling "print to file." | |I tried the SendKeys? Action to send %l (ALT-l) and a file name, but Access |just sat there with the Print Dialog box, and would get no further. Any ideas? |_____________________________________________________________________ __________ |Robert Reed Home Animation Ltd. 503-656-8414 |robert@slipknot.rain.com 5686 First Court, West Linn, OR 97068 | |I went to a museum where they have all the heads and arms of the statues |in the other museums |--Steve Wright |_____________________________________________________________________ __________ | | ========================================================================= Date: Tue, 2 Mar 1993 08:58:01 CST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: randy legeai Subject: Mailing Labels I've been having a strange problem printing mailing labels from Access on my trusty old Panasonic KX-P1180 dot matrix printer. If I set up labels using the formwizard, they look fine on the screen, but when they print on the DMP, the top of the first label doesn't print. Instead, the first label starts with the second line, and all labels are then thrown off by that amount. Then, there is a form-feed before the last label prints. I have selected the correct Avery label, and cannot figure out what else could be causing this problem. I had a similar problem when I experimented with Approach some time ago. Any suggestions would be appreciated. -- Randall Legeai rlegeai@rs1.tcs.tulane.edu Federal Agency Affairs / Ctr. Bioenv. Research Phn: 504/865-5758 327 Gibson Hall, Tulane University Fax: 504/865-5274 New Orleans, Louisiana 70118-5698 ========================================================================= Date: Tue, 2 Mar 1993 10:17:47 -0800 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: lrw@SDSC.EDU Subject: Calculated field problem I am having a problem which looks an awful lot like a bug in Access to me. I have a database with a text field called [First Name]. When I print a report with the cell value being either First Name or [First Name], then the report is fine. However if I make the cell a calculated field (i.e. =[First Name]), then the field in the report is printed as #error. The reason It is all so fishy is that if I substitute another identically defined field for First Name it works in all of the cases. Has anyone seen this before? Does anyone have a work around? I just want to string the first and last names together in the form of =[First Name]&" "&[Last Name] Len Wanger lrw@sdsc.edu San Diego Supercomputer Center ========================================================================= Date: Tue, 2 Mar 1993 11:08:12 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Gene Marshall Subject: Re: Calculated field problem In-Reply-To: <9303021835.AA13904@hpcuoa.sv.itc.hp.com>; from "lrw@SDSC.EDU" at Mar 2, 93 10:17 am > > I am having a problem which looks an awful lot like a bug in Access to > me. Nop! > ... the field in the report is printed as #error. Hi Len, As a new user, I get this a lot. The problem (with me anyway) is the first field in the 'properties' list. The control needs to be a new (unique) name. You are probably leaving it as FirstName. Here access wants to use the data in that field, yet you are defining it to be a (potentially) different value. Just change that first field (or control) name from FirstName to something like FirstName_calculated. Have fun... Gene +----------------------------------------------------------------------------+ |Gene Marshall /-/-/ email: genem@.hp.com | |Hewlett Packard Co., MS 42UN | Tel: 408/447-5282 | |Software Technology Division (SWT) | Fax: 408/447-5039 | |11000 Wolfe Road | AA6IY@N6LDL.CA.USA.NA | |Cupertino, CA 95014 /|\ Bay Area: 147.39+ / 223.96- | +----------------------------------------------------------------------------+ ========================================================================= Date: Tue, 2 Mar 1993 12:28:36 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Morris Myers Subject: Re: Mailing Labels ----- Begin Included Message ----- I've been having a strange problem printing mailing labels from Access on my trusty old Panasonic KX-P1180 dot matrix printer. If I set up labels using the formwizard, they look fine on the screen, but when they print on the DMP, the top of the first label doesn't print. Instead, the first label starts with the second line, and all labels are then thrown off by that amount. Then, there is a form-feed before the last label prints. I have selected the correct Avery label, and cannot figure out what else could be causing this problem. I had a similar problem when I experimented with Approach some time ago. Any suggestions would be appreciated. ----- End Included Message ----- I've seen this same bug using MicroSoft Word mail merge to print labels. I don't have a work-around. I suspect the problem may be inherent in Microsoft 'scripts' that print labels. If I find a way around the problem I'll post it. If anyone else figures out how to make Access work right I will try to apply that solution to MS Word. ========================================================================= Date: Wed, 3 Mar 1993 08:38:04 MDT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" Comments: Converted from PROFS to RFC822 format by PUMP V2.1 From: "Brian Keeler (403) - 471-8623" Subject: Calculated field problem In-Reply-To: note of 93-03-02 18:55 to string the firstname and last name together use the following command: ="|[firstname]| |[lastname]|" this will also eliminate spaces etc. from the firstname field. I used this in a REPORT option Brian Keeler (403) - 471-8623 Application Services Coordinator Information Services Division domain: briank@nait.ab.ca ========================================================================= Date: Wed, 3 Mar 1993 09:03:27 PDT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Mark Barnet (Business Enter. Syst. Tech)" Subject: RE: Calculated field problem The field name on the report/form must not equal the source name if you expect to use a function as the source. eg. given field in database called [Field] given form field called [Field] with source called [Field] or Field ==> success given form field called [Field] with source called =[Field] ==> failure (recursive reference to itself) given form field called [F1] with source called [Field] or Field or =[Field] ==> success (no recursiveness here!) ---------- |From: |To: Multiple recipients of list ACCESS-L |Subject: Calculated field problem |Date: Tuesday, March 02, 1993 10:17AM | |I am having a problem which looks an awful lot like a bug in Access to |me. | |I have a database with a text field called [First Name]. When I print a |report with the cell value being either First Name or [First Name], then |the report is fine. However if I make the cell a calculated field (i.e. |=[First Name]), then the field in the report is printed as #error. The |reason It is all so fishy is that if I substitute another identically |defined field for First Name it works in all of the cases. | |Has anyone seen this before? Does anyone have a work around? I just want |to string the first and last names together in the form of |=[First Name]&" "&[Last Name] | |Len Wanger |lrw@sdsc.edu |San Diego Supercomputer Center | | ========================================================================= Date: Wed, 3 Mar 1993 09:22:40 -0800 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: lrw@SDSC.EDU Subject: Re: Calculated field problem In-Reply-To: Your message of "Wed, 03 Mar 93 09:03:27 PDT." <9303031700.AA08202@sluggo.sdsc.edu> > The field name on the report/form must not equal the source name if you > expect to use a function as the source. > eg. > given field in database called [Field] > given form field called [Field] with source called [Field] or Field ==> success > given form field called [Field] with source called =[Field] ==> failure > (recursive reference to itself) > given form field called [F1] with source called [Field] or Field or > =[Field] ==> success (no recursiveness here!) Thanks to the various Access sages who pointed out the error in my ways! This was indeed the problem. I also appologize to the Access team for implying that there was a bug. I do believe this problem might be a good candidate of this group ever puts together a FAQ list (and maybe for Microsoft to add to the Q&A file). Several other people also mentioned to me that they had experienced this problem. Len Wanger ========================================================================= Date: Wed, 3 Mar 1993 12:47:40 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Nathan C. Brindle" Subject: FAQ list In-Reply-To: Message of Wed, 3 Mar 1993 09:22:40 -0800 from If someone wants to develop a FAQ list for ACCESS-L, I will try to get disk space to store it on. My life is already busy enough...:)...but if all I have to do is store it, I think it's something we should offer. Anyone interested in producing such a compilation should contact me directly via private mail. By the way, I think the bouncing mail situation has cleared up. I haven't gotten any errors back for two days, meaning (I hope) that the Internet domain list here at INDYCMS has been updated. Fingers are crossed. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Wed, 3 Mar 1993 13:49:16 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Sunday EVERYDAY Subject: Re: FAQ list In-Reply-To: from "Nathan C. Brindle" at Mar 3, 93 12:47:40 pm > > If someone wants to develop a FAQ list for ACCESS-L, I will try to get > disk space to store it on. My life is already busy enough...:)...but > if all I have to do is store it, I think it's something we should offer. > > Anyone interested in producing such a compilation should contact me directly > via private mail. kinda funny. I just downloaded the FAQ from Microsoft, so i'll be uploading them soon. (by the end of this week). :) (yes, i'm too lazy to respond personally, nate.:) > > -----------------------------------------------------BITNET: NBRINDLE@INDYCMS > Nathan C. Brindle, Student Activities Office > Indiana University Purdue University Indianapolis > Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER > List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS > Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU > ------------------------------------------------------------------------------ > -jon ========================================================================= Date: Wed, 3 Mar 1993 12:28:02 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "ROBERT GRINNELL, SEATTLE PACIFIC UNIVERSITY" Subject: FoxPro list? Does anyone know of a list/forum for FoxPro? Robert Grinnell Seattle Pacific University r_grinnell@luke.spu.edu ========================================================================= Date: Wed, 3 Mar 1993 13:17:42 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Tony Tam Hi, I need help in implementing pop up forms in ACCESS. What I want to do is to have a Combo box for a list of customers in a 'Inventory' form and let the user either type in a name or select it from the list. If the customer is not in the list, the user can pop up another form to add a customer. But I want to have the pop up form to add the customer that the user typed and I want the pop form to be modal. Since in the customer form, there might be a 'Zip' code Combo Box that the user can pop up and add a zip code and so on. The problem is that when I open up the form as modal, the code doesn't continue until the modal form is closed. This customer form may be called from any number of other forms so I don't want any code on the 'customer' form to reference specify forms. Any ideas? --------------------- Tony Tam :) | tonyt@cimsim.berkeley.edu ========================================================================= Date: Wed, 3 Mar 1993 13:39:00 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Tony Tam Subject: Re: Tab move Sequence in form >Unfortunately disabling it is not going to suit the purpose. I want >to have a button that operates that isn't in the tab order. I guess >I'll have to wait for the next version or try something that someone >else suggested in private mail, that is, put the button in the header >or footer of the form. What about changing the OnExit property of the control that has the tab order before your button to skip to the next control? Write a ACCESS function called GotoToControl() and set the OnExit property of the previous control to be '=GotoControl("NextControl") -------------------------------------------- Function GotoToControl(ctrlName As String) DoCmd GotoControl ctrlName // I think the name of the Macro is GotoControl End Function ----------------------------------------------------------------------------- Tony Tam :) | tonyt@cimsim.berkeley.edu (Internet) ========================================================================= Date: Wed, 3 Mar 1993 18:24:04 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: prevo@BLOT.KSC.NASA.GOV Subject: Re: Tab move Sequence in form In-Reply-To: Your message of "Wed, 03 Mar 93 13:39:00 PST." >What about changing the OnExit property of the control that has the >tab order before your button to skip to the next control? > >Write a ACCESS function called GotoToControl() and set the OnExit property >of the previous control to be '=GotoControl("NextControl") > >-------------------------------------------- >Function GotoToControl(ctrlName As String) > > DoCmd GotoControl ctrlName // I think the name of the Macro is GotoControl > >End Function > >----------------------------------------------------------------------------- >Tony Tam :) | tonyt@cimsim.berkeley.edu (Internet) But how do you know if you're exiting the control in a backward or forward direction? That was my only problem with this approach. Joe ========================================================================= Date: Wed, 3 Mar 1993 12:43:37 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Rickey Thomas Tom I hope someone out there can solve the following problem I have two tables table1 table2 lastName firstName lastName tom doug tom john doug john jackson mathew john wilson I need an SQL statement which will 1) fetch all lastnames from table1 WHICH ARE NOT in Table2 and the firstname is doug Such a query, when applied to the above will return a list from table1 which include jackson, wilson. The lastname fields are foreign keys. In the lastest ANSI SQL standard, I could just use SELECT lastName * from table1 where lastname not in (select lastname from table 2 where firstname = "doug") It appears that the in() statement in Access does not allow another select statement (syntax error is posted) Any help or suggestions would be greatly appreciated. Thank you in advance ========================================================================= Date: Wed, 3 Mar 1993 12:46:06 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Rickey Thomas Tom Subject: help with multi table queries I hope someone out there can solve the following problem I have two tables table1 table2 lastName firstName lastName tom doug tom john doug john jackson mathew john wilson I need an SQL statement which will 1) fetch all lastnames from table1 WHICH ARE NOT in Table2 and the firstname is doug Such a query, when applied to the above will return a list from table1 which include jackson, wilson. The lastname fields are foreign keys. In the lastest ANSI SQL standard, I could just use SELECT lastName * from table1 where lastname not in (select lastname from table 2 where firstname = "doug") It appears that the in() statement in Access does not allow another select statement (syntax error is posted) Any help or suggestions would be greatly appreciated. Thank you in advance Rick ========================================================================= Date: Wed, 3 Mar 1993 19:38:42 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: George Raudabaugh My general question on this, is there a way to do an kind of subselect (or sub query or nested select - take your pick) in Access? I've had zero luck in this and would guess its a FAQ. GR. -- George Raudabaugh Manager/Document Technologies Information Dimensions, Inc. raudabaugh@idicl1.idi.battelle.org (work email) 5080 Tuttle Crossing Blvd. Dublin, Ohio 43017 (614) 761-7309 (voice mail) >From: IN%"ACCESS-L%INDYCMS.BITNET@pucc.Princeton.edu" "Microsoft Access Databa se Discussion List" 3-MAR-1993 19:02:46.69 >To: IN%"ACCESS-L%INDYCMS.BITNET@pucc.Princeton.edu" "Multiple recipients of li st ACCESS-L" >CC: >Subj: > >I hope someone out there can solve the following problem > > >I have two tables > >table1 table2 > lastName firstName lastName > tom doug tom > john doug john > jackson mathew john > wilson > >I need an SQL statement which will > >1) fetch all lastnames from table1 WHICH ARE NOT in Table2 and the firstname is > doug > >Such a query, when applied to the above will return a list from table1 which >include jackson, wilson. The lastname fields are foreign keys. > >In the lastest ANSI SQL standard, I could just use > >SELECT lastName * from table1 where lastname not in > (select lastname from table 2 where firstname = "doug") > >It appears that the in() statement in Access does not allow another select >statement (syntax error is posted) > > >Any help or suggestions would be greatly appreciated. Thank you in advance ========================================================================= Date: Thu, 4 Mar 1993 02:01:32 -0800 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Dmitry Serebrennikov Subject: Re: Tab move Sequence in form In-Reply-To: <9303032326.AA15443@nettlerash.berkeley.edu> from "prevo@BLOT.KSC.NASA.GOV" at Mar 3, 93 06:24:04 pm How about moving this one button to the end of your tab order (you can group all such buttons there) and then set OnEnter property of the first one of them to run a macro that sends you to the first object in tab order, and OnEnter in the last one to send you to the last object. Dmitry Serebrennikov dmitry@ucsee.berkeley.edu ========================================================================= Date: Thu, 4 Mar 1993 09:32:36 CST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Steve Carr Subject: Searching Subforms Can I search subform records to filter records in the parent form? The documentation says you can't do it, but then elsewhere I've seen examples of expressions that refer to controls on the subform. ####################################################################### Join the Progressive Jewish Mailing List (PJML) for an open discussion. Send the following message to LISTSERV@UTXVM.BITNET or LISTSERV@UTXVM.CC.UTEXAS.EDU: SUB PJML Join the Progressive Jewish Activism List (PJAL) for a moderated discussion. Send the following message to LISTSERV@UTXVM.BITNET or LISTSERV@UTXVM.CC.UTEXAS.EDU to receive an application: SUB PJAL ####################################################################### Steve Carr carr@emx.cc.utexas.edu Dept. of Radio-TV-Film 512/471-4071 20903 fax: 512/471-4077 University of Texas at Austin Austin TX 78712 ========================================================================= Date: Thu, 4 Mar 1993 09:38:10 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "ROBERT GRINNELL, SEATTLE PACIFIC UNIVERSITY" Subject: Implementing pop-up forms On Wed, 3 Mar 1993 13:17:42 PST, Tony Tam wrote: >Hi, I need help in implementing pop up forms in ACCESS. What I want to do >is to have a Combo box for a list of customers in a 'Inventory' form and let th e >user either type in a name or select it from the list. If the >customer is not in the list, the user can pop up another form to add a customer . >But I want to have the pop up form to add the customer that the user typed and I >want the pop form to be modal. Since in the customer form, there might be a > 'Zip' code >Combo Box that the user can pop up and add a zip code and so on. >The problem is that when I open up the form as modal, the code doesn't continue > until >the modal form is closed. This customer form may be called from any number of > other forms >so I don't want any code on the 'customer' form to reference specify forms. I'm not sure I have interpretted your question correctly, but here's a stab at it. (I'm coming from a Visual Basic background, just beginning in Access, so plz excuse if something doesn't fit quite right.) Let's say you have an order entry form, on which one control is a combo box of customer names. If the user doesn't find the name in the list, he types in a new name. Event code for the combo box captures this, and from this point, you want to put the user into a form for entry of all pertinent customer data before continuing with order entry. But other forms in your system (perhaps invoice preparation, etc.) need to be able to do the same thing - add a new customer. Implement the handling of the New Customer form through a function procedure, which can be called from any other procedure/form. The function [let's call it AddNewCustomer()] pops up the New Customer form as modal to collect the info. Set up the function such that you pass it the string of the new name the user entered. Have it return a value or string that you can use in the caller routine to determine whether a new customer was added successfully, maybe the new customer's ID or name (in final form), or the value False if the customer was not added successfully. BTW, if you need a user to enter just one item on a pop-up form, just use the MsgBox function (not statement). This would do for something like your zip code example. Hope this helps. Robert Grinnell Seattle Pacific University r_grinnell@luke.spu.edu ========================================================================= Date: Thu, 4 Mar 1993 10:56:38 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Tony Tam Subject: Re: Implementing pop-up forms > > other forms > >so I don't want any code on the 'customer' form to reference specify forms. > > I'm not sure I have interpretted your question correctly, but here's a stab > at it. (I'm coming from a Visual Basic background, just beginning in Access, > so plz excuse if something doesn't fit quite right.) > > Let's say you have an order entry form, on which one control is a combo box > of customer names. If the user doesn't find the name in the list, he types in > a new name. Event code for the combo box captures this, and from this point, > you want to put the user into a form for entry of all pertinent customer > data before continuing with order entry. But other forms in your system > (perhaps invoice preparation, etc.) need to be able to do the same thing - > add a new customer. > > Implement the handling of the New Customer form through a function procedure, > which can be called from any other procedure/form. The function [let's call > it AddNewCustomer()] pops up the New Customer form as modal to collect the > info. Set up the function such that you pass it the string of the new name > the user entered. Have it return a value or string that you can use in the > caller routine to determine whether a new customer was added successfully, > maybe the new customer's ID or name (in final form), or the value False if > the customer was not added successfully. > But the problem is that how do I pass in the customer name that the user typed into a modal form? Thanks --------------------- Tony Tam :) | tonyt@cimsim.berkeley.edu ========================================================================= Date: Thu, 4 Mar 1993 16:44:24 -0800 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Dmitry Serebrennikov Subject: Editing Question Hello, I hope someone has come across of what I am trying to do: does any one have a suggestion on what was the intended way to handle a situation like following in Access I have a form with customer information (address etc.) and do not want to let user edit the information accidentally, i.e. I want for user to have to press some button before he is allowed to edit any of the fields. I have implemented this using a button that runs MenuCommand "Editing Allowed" (because I didn't find how to do this with just macro commands). Thus I have the form come up with editing disabled and then I can toggle that with the button. My problem is that now I am changing the design and now I will have some fields in the header of the form that I *want* user to edit (such as search criteria), but my scheme prevents user from changing those fields too. My question is can anyone think of another way to implement this so that I prohibit editing only sertain fields and that I can controll that with a button? Thanks Dmitry Serebrennikov dmitry@ucsee.berkeley.edu ========================================================================= Date: Fri, 5 Mar 1993 09:15:43 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "ROBERT GRINNELL, SEATTLE PACIFIC UNIVERSITY" Subject: Re: Implementing pop-up forms >But the problem is that how do I pass in the customer name that the user >typed into a modal form? On your new customer form, you'll have a text box for the customer's name. Set the value of that text box to the name which is passed to the function, BEFORE displaying the form, like: frmNewCustomer!txtCustomerName = $NewName where $NewName is the variable in function's definition. Robert Grinnell Seattle Pacific University r_grinnell@luke.spu.edu ========================================================================= Date: Fri, 5 Mar 1993 16:57:11 -0800 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" Comments: Warning -- original Sender: tag was redl@CARSON.U.WASHINGTON.EDU From: Ned Logan Subject: Mailing list Please unsubscribe me to the ACCESS-L mailing list. I don't have access to ACCESS any more. Thank you very much. Ned ========================================================================= Date: Sun, 7 Mar 1993 10:11:10 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Tony Tam Subject: Re: Implementing pop-up forms > >But the problem is that how do I pass in the customer name that the user > >typed into a modal form? > > On your new customer form, you'll have a text box for the customer's name. > Set the value of that text box to the name which is passed to the function, > BEFORE displaying the form, like: > > frmNewCustomer!txtCustomerName = $NewName > > where $NewName is the variable in function's definition. > Thanks for all your help. But either I'm not reading the manual correctly for Access Basic or you might not that familar with Access. In order to open a form, we have to use a syntax like: OpenForm "FormName", A_NORMAL,..., [A_DIALOG]|[A_NORMAL]|[A_ICON]|[A_HIDDEN] So if I want to open the form in A_DIALOG, the code would not continue until the form is closed, which makes sense for a MODAL DIALOG BOX. But after I open the form, how do I set the values since the code would not continue until the form is closed? Sorry if I'm either not asking the right question or that I'm missing something. --------------------- Tony Tam :) | tonyt@cimsim.berkeley.edu ========================================================================= Date: Mon, 8 Mar 1993 09:13:03 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Toby Rockwell Subject: Forcing Capital Letters In-Reply-To: <9303080316.AA21072@worldlink.worldlink.com> I had no problem forcing letters in my state and (Canadian) zip code fields to be all caps (> in format), but when a report is generated to print out mailing labels, the damned letters revert to lower case. looking at the output of the underlying query shows upper case as does the base table. However entering an individual field to edit it in the base table does indicate that the stored characters are indeed lower case. So how does one force the actual storage of the characters to be upper case, or alternatively force the output of the report to print as upper case? ========================================================================= Date: Mon, 8 Mar 1993 08:47:00 CST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: miguelr@IHLPE.ATT.COM Subject: Re: Forcing Capital Letters No, you have to specify the '>' as part of the field definition when you define the table (format field). Or, you can specify the '>' as part of your report. Miguel A. Rivera AT&T Bell Labs. Naperville, IL. 60563 ========================================================================= Date: Mon, 8 Mar 1993 10:08:50 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Nathan Brindle" Subject: Re: Forcing Capital Letters In-Reply-To: Message of Mon, 8 Mar 1993 08:47:00 CST from True. What he wants can be accomplished by setting the format property of the text box on the report to ">". If he wants to have the table field default to all caps, he needs to set the format property of the field accordingly. (I know this is repetetive, but I'm trying to track down a couple of mail bounces and thought I would chime in. Sorry...) -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 8 Mar 1993 12:25:52 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Toby Rockwell Subject: ReQuery: Forcing Capital Letters In-Reply-To: <9303081513.AA04958@worldlink.worldlink.com> Perhaps I didn't make my exact requirements clear. '>' alone will apparently not fulfil my requirements thusly: >True. What he wants can be accomplished by setting the format property >of the text box on the report to ">". Except that my text reads: [city]&", "&[state]&" "&(etc.) so the entire text box cannot be set to UpperCase as I only want the State in Uppers. >If he wants to have the table field >default to all caps, he needs to set the format property of the field >accordingly. Assuming that what is meant here is to simply put a '>' into the format line, I would have thought that this would work as well. This was my original method as it happens. When one looks at the table itself, or a subsequent query, the state field will be "displayed to the screen" as UpperCase. If, however, the cursor is put into the state field for editing; the actual text entered in the field (and the text that is subsequently printed out in the report) is found to be *still* the same form that it was entered as originally. In other words, only the display of the field appears to be affected, not the underlying data stored in the field. So, my question remains ========================================================================= Date: Mon, 8 Mar 1993 13:04:35 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Toby Rockwell Subject: Re: Forcing Capital Letters In-Reply-To: <9303081513.AA04958@worldlink.worldlink.com> Mea Culpa, mea maxima culpa Tough problems yield, little ones fester. I self-found the solution as I should have before, an in line format statement: [city]&", "&format([state],">")&" "(etc.) which works just fine. I WOULD like to know, why doesn't the actual value in the table get stores as it is formatted? ========================================================================= Date: Mon, 8 Mar 1993 20:58:02 SAT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Trevor D. Rotzien" Subject: Repetitive display of main form rows in left join Greetings, I have just begun to develop Access db's for my colleagues, and would be enjoying it without reservation, except for one problem: In a form/subform view, the data from the main row is repeated as many times as there are matching rows in the subform for that main row. The form has as it's source a left join query. These redundant rows ONLY appear in the view, and not in the table. The fact that the repetition number is exactly equal to the number of matching rows in the subform implies to me that the wording of my query is at fault, but I can't see any obvious problem. For those of you who are SQLiterate, I'll forward the text of the query shortly. Thanks for any and all suggestions! ---------------------------------------------------------------------- trevor d. rotzien marine science group k.f.u.p.m. box 118 water resources & environment division dhahran 31261 the research institute saudi arabia king fahd university of petroleum & minerals email: rsiu42a@saupm00.bitnet office: -966-03-860-4316 ---------------------------------------------------------------------- ========================================================================= Date: Mon, 8 Mar 1993 19:10:57 EDT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Steve Miller Subject: Re: Tab move Sequence in form In-Reply-To: <9303082335.AB11191@gateway.pictel.com>; from "Revised List Processor" at Mar 8, 93 6:39 pm > Date: Wed, 3 Mar 1993 18:24:04 -0500 > Reply-To: "Microsoft Access Database Discussion List" > > Sender: "Microsoft Access Database Discussion List" > > From: prevo@BLOT.KSC.NASA.GOV > Subject: Re: Tab move Sequence in form > In-Reply-To: Your message of "Wed, 03 Mar 93 13:39:00 PST." > > >What about changing the OnExit property of the control that has the > >tab order before your button to skip to the next control? > > > >Write a ACCESS function called GotoToControl() and set the OnExit property > >of the previous control to be '=GotoControl("NextControl") > > > >-------------------------------------------- > >Function GotoToControl(ctrlName As String) > > > > DoCmd GotoControl ctrlName // I think the name of the Macro is GotoControl > > > >End Function > > > >----------------------------------------------------------------------------- > >Tony Tam :) | tonyt@cimsim.berkeley.edu (Internet) > > But how do you know if you're exiting the control in a backward or forward > direction? That was my only problem with this approach. > > Joe In order to get around this problem, use a dummy control, usually an unbound text box. You add this dummy control between the the last control you want in the tab order and the button, like this: Control_1 Control_2 Control_3 Dummy_Control Button_1 Button_2 Now, set the OnEnter property of the Dummy_Control to a macro which goes to Control_1. This results in a backwards tab from Control_3 going to Control_2 and a forward tab going to Control_1. The key to this is the Dummy_Control. This has to be a visible control. However, if you make it really small and put it near the edge of the form, it isn't visible. Just make sure you remember where you put it on the form so that you can find it if you need to. -- +-------------------------------------------------------+ | Steve Miller PictureTel Corporation | | email: miller@pictel.com One Corporation Way | | phone: (508) 977-8235 Peabody, MA 01960 | +-------------------------------------------------------+ ========================================================================= Date: Tue, 9 Mar 1993 07:25:26 SAT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Trevor D. Rotzien" Subject: Repeated main rows in form/subform This query is used as the record source for a form/subform: FROM Main List, Synonyms, I want all records in Main List to be displayed once, and any records matching the join criteria to be displayed in the subform. What I am getting is a matching record in Main List repeated for as many times as there are matching records in Synonyms. The matching records in Synonyms are displayed correctly in the subform. Comments? ---------------------------------------------------------------------- trevor d. rotzien marine science group k.f.u.p.m. box 118 water resources & environment division dhahran 31261 the research institute saudi arabia king fahd university of petroleum & minerals email: rsiu42a@saupm00.bitnet office: -966-03-860-4316 ---------------------------------------------------------------------- ========================================================================= Date: Tue, 9 Mar 1993 16:30:27 +1000 Reply-To: j.briganti@trl.oz.au Sender: "Microsoft Access Database Discussion List" From: Joe Briganti Subject: changing a report-wizard generated report How do you make changes to report-wizard generated reports. For example, say I have created a mailing label report using the wizard and I used say avery-label 1562 (English) but want to change it (after I've saved the report) to say 1563? I've checked the manual and it only refers to changing the formats of the fields selected etc. The same would apply to I guess whether you originally selected "executive" style but then after saving decide you want "ledger" style. A reference to manual would be appreciated in addition to any help in this matter. Thanks in advance. -- Joe Briganti ( j.briganti@trl.oz.au ) Contractual obligations prevent me from speaking on behalf of my employer. ========================================================================= Date: Tue, 9 Mar 1993 09:08:17 GMT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Anne L Zorner R27.G5/" Subject: repeated rows in query containing join SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB =============================================================== What you have not done is ensured that a join condition of the type table1.X=table2.Y is encoded in the query. This is done either by specifying a relationship or adding it into the WHERE clause. Select A.b, A.c, B.aa, B.cc from A,B where A.b = B.b When joining a table to another (be it itself a view or anything) this type of where clause mus be used, if outer join is needed then use the syntax for that. All these are also specifiable using the graphical relationship tool as well. Anne Thankyou =============================================================== ========================================================================= Date: Tue, 9 Mar 1993 09:46:19 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Gerry Roston Subject: Help using dynaset within AB It is my turn to ask for help. I spoke with the tech support folks, but the answer was not complete. I followed up with the following (as a Fax) but they never responded. If the following description is incomplete, please let me know and I will add the additional required information. Your help is appreciated. (p.s. When I get this done, I have no problem sharing the results with y'all.) I have a report, named BibReport, based on a query. Because of the nature of the output, I did not use the Report Wizard to create this report, rather I started with a blank report and added a single, unbound control to the section. Looking at the properties, the Record Source for the report is Search, the Control Name for the single text box is Text1111 and the Control Source is shown as =OD(). The query, Search, is also quite simple. The first column sorts the table based on one of the fields, and the second uses a Like criteria to limit the records. Because of the type of application, the query property Restrict Available Fields is not selected, i.e., I want all fields to appear in the dynaset. So, now we must look at OD(). The purpose of this function is to format the output properly. Since my table has 25 fields, I am only showing a simplified version of this module: Option Compare Database 'Use database order for string comparisons Option Explicit Function OD () As String Dim ds As Dynaset Dim toe, an, au, jnl, kw, mn, note, num, pp, tl, vol, yr As String Dim workString As String Set ds = Reports!BibReport.Dynaset toe = ds![type of entry] 'type of entry, Author and Title are all defined au = ds![Author] 'fields in my table, and also in the dynaset tl = ds![Title] '[rest of variable assignments removed for brevity] Select Case toe Case "Article" workString = au & ". " & tl & ". " & jnl & ", " If Not IsNull(vol) Then OD = OD & vol If Not IsNull(num) Then OD = OD & "(" & num & ")" If Not IsNull(pp) Then OD = OD & ":" & pp & ", " Else OD = OD & ": " If Not IsNull(mn) Then OD = OD & mn & " " OD = OD & yr If Not IsNull(kw) Then OD = OD & Chr(13) & Chr(10) & "Keywords: " & kw If Not IsNull(an) Then OD = OD & Chr(13) & Chr(10) & an End Select OD = workString End Function When I open the report in preview mode, I get a pop-up-window with the message Couldn't Find field 'type of entry'. However, this field does exist in the table, and I assume in the query also because of the query property mentioned above. The is not a typographical error as I have tried this with many of the fields and consistently get the same result. To try an figure out what was going on, I found the following routine in The Language Reference, page 163. Sub Print_Field_Names () Dim ListSet As Snapshot Set ListSet = Reports!BibReport.Dynaset.ListFields() ListSet.MoveFirst Do Until ListSet.EOF Debug.Print ListSet.Name ListSet.MoveNext Loop End Sub I ran this program in the Immediate Window and the result I got was #NULL#. So, some how, the fields are getting lost. However, when I print the value of Reports!BibReport.Dynaset.RecordCount, it prints a value of 18, which is correct! Now, if one of you is really up to the challenge, try the following (but I am certain that it can not be done): In the block of code shown above, routine OD, figure out how to make certain items appear in the regular font and part in italic font! Gerry Roston (gerry@cmu.edu) | A man's ethical behavior should be based Field Robotics Center, | effectually on sympathy, education, and Carnegie Mellon University | social ties; no religious basis is Pittsburgh, PA, 15213 | necessary. Man would indeed be in a poor (412) 268-3856 | way if he had to be restrained by fear and | punishment and hope of reward after death. The opinions expressed are mine | Albert Einstein and do not reflect the official | position of CMU, FRC, RedZone, | or any other organization. | ========================================================================= Date: Wed, 10 Mar 1993 11:00:40 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Tony Tam Subject: changing a report-wizard generated report In-Reply-To: Joe Briganti's message of Tue, 9 Mar 1993 16:30:27 +1000 <9303090632.AA09588@nettlerash.berkeley.edu> >How do you make changes to report-wizard generated reports. >For example, say I have created a mailing label report using the >wizard and I used say avery-label 1562 (English) but want to change >it (after I've saved the report) to say 1563? >I've checked the manual and it only refers to changing the formats >of the fields selected etc. >The same would apply to I guess whether you originally selected >"executive" style but then after saving decide you want "ledger" style. >A reference to manual would be appreciated in addition to any help in this >matter. I believe you can just use ACCESS to open the wizard.mda and change the code in there. I think you'll have to rename it wizard.mdb and uncomment the line in your msaccess.ini to not use the wizard.mdb in the [utility] section. Hope it helps ---------------------------------------------------------------------- "Never be afraid of asking questions" Tony Tam tonyt@cimsim.berkeley.edu ---------------------------------------------------------------------- ========================================================================= Date: Thu, 11 Mar 1993 13:08:22 EST Reply-To: ACCESS-L@INDYCMS.BITNET Sender: "Microsoft Access Database Discussion List" From: "Nathan Brindle" Subject: Re: Repeated main rows in form/subform The following message was returned to me as an error. Several lines of header have been excised to make it palatable to the system. REPOSTED MESSAGE BEGINS: Message-Id: <9303111643.AA09998@ottawa.opl.com> Received: by hamilton (16.8/16.2) id AA11813; Thu, 11 Mar 93 11:43:46 -0500 Date: Thu, 11 Mar 93 11:43:46 -0500 From: Kawi Neal > Message-Id: <9303090434.AA11037@ottawa.opl.com> > Received: from PUCC.PRINCETON.EDU by pucc.Princeton.EDU (IBM VM SMTP V2R2) > with BSMTP id 1886; Mon, 08 Mar 93 23:33:01 EST > Received: from PUCC.BITNET (NJE origin LISTSERV@PUCC) by PUCC.PRINCETON.EDU (LMail V1.1d/1.7f) with BSMTP id 5512; Mon, 8 Mar 1993 23:33:01 -0500 > Date: Tue, 9 Mar 1993 07:25:26 SAT > From: "Trevor D. Rotzien" > Subject: Repeated main rows in form/subform > Status: RO > This query is used as the record source for a form/subform: > FROM Main List, Synonyms, > I want all records in Main List to be displayed once, and any records > matching the join criteria to be displayed in the subform. What I am > getting is a matching record in Main List repeated for as many times > as there are matching records in Synonyms. The matching records in > Synonyms are displayed correctly in the subform. > Comments? > ---------------------------------------------------------------------- > trevor d. rotzien marine science group > k.f.u.p.m. box 118 water resources & environment division > dhahran 31261 the research institute > saudi arabia king fahd university of petroleum & minerals > email: rsiu42a@saupm00.bitnet > office: -966-03-860-4316 > ---------------------------------------------------------------------- Note : Disregard previous mail.....accidentally sent off before completion.. Seems like you have a one-to-one relationship between the Main List and Synonyms "Matching record in Main List repeated for as many times as there are matching records in Synonyms." What you could do is create two querries ( MainList & Synonyms ) Set the Properties of the MainList querry to Unique Values. Note : Your form will now be base on unique MainList values and base the Synonyms querry on the Control in the Main List form that contains the join criteria (the unique matching value). Note : You can use control ( [ContrlName]) values as the basis of you criteria. Kawi Neal neal@opl.com MARCAM REPOSTED MESSAGE ENDS -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Thu, 11 Mar 1993 16:00:20 EST Reply-To: "Nathan Brindle" Sender: "Microsoft Access Database Discussion List" From: "Nathan Brindle" Subject: Joining with MS-ACCESS list I have been in correspondence with Georg Chytil, who runs another Access list in Europe, regarding merging our two lists. Unfortunately, it isn't as easy as it sounds, and the closest we can come to this is giving him a "full feed" of ACCESS-L without a direct return connection to MS-ACCESS. This would unfortunately mean that some people who want to subscribe to both lists would receive some duplicate mail. Georg and I believe that there is enough interest on both sides to support this even though some people will get some duplication of mail. I would like to go ahead with this project, but if there is a great deal of negative feedback from ACCESS-L subscribers, I will bow to the will of the majority. Please send comments to me directly, rather than responding to the list. Sincerely, -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Thu, 11 Mar 1993 16:44:55 CST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Brian M. Glasgow" Subject: Runtime licensing for Access Can anyone give me information concerning a Run_time License for MS- Access. (AKA Added Value reseller packaging) I have developed a few good applications that I would like to sell as stand-alone applications but am reluctant to sell the whole Access Package (particularly at the new Suggested Price) ========================================================================= Date: Thu, 11 Mar 1993 15:57:18 MDT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" Comments: Converted from PROFS to RFC822 format by PUMP V2.1 From: "Brian Keeler (403) - 471-8623" Subject: Microsoft Access - IIf function From the database I have created, fields eg. name address1 address2 city province postalcode, I am creating a report. The problem is that address2 is NULL sometimes, thus when you view or print the report you get output lines on Report line1 Brian Keeler Brian Keeler line2 8403-44 avenue or 8403-44 avenue line3 Apartment 201 line4 Edmonton Alberta T6K0Z6 Edmonton Alberta T6K0Z6 What I used so that if address2 was NULL it would move the next line up and I would have another function statement to put in a blank line on line 4 when address2 is null, this is right out of the user's guide Page 485 and it does not work. =IIf([address2]Is Null,"|[city]| |[province]| |[postalcode]|","[address2]") Could someone please explain why or give me a solution to work around this problem. Have I found a bug?? because when you look in the user guide manual and compare the online help for the same IIf function the syntax is different. I have tried both... thanks in advance... Brian Keeler (403) - 471-8623 Application Services Coordinator Information Services Division domain: briank@nait.ab.ca ========================================================================= Date: Fri, 12 Mar 1993 17:19:21 -0800 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Dmitry Serebrennikov Subject: Re: Runtime licensing for Access In-Reply-To: <9303112248.AA24746@nettlerash.berkeley.edu> from "Brian M. Glasgow" at Mar 11, 93 04:44:55 pm > > Can anyone give me information concerning a Run_time License for MS- > Access. (AKA Added Value reseller packaging) I have developed a few > Along the simular lines: has anyone heard of a compiler for ACCESS? I heard that it is being developed, but I don't know if that's true. ========================================================================= Date: Fri, 12 Mar 1993 18:21:52 -0700 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: FELLOWS STEVEN B Subject: Re: Runtime licensing for Access I called Microsoft lastweek and asked them about this. They said that a runtime licenseing version is in the works. It would probably be priced the same as Access, but would enable you to give your compiled database to a user who does not have Access. This was according to a saleswoman. Steven B. Fellows sfellows@slate.mines.colorado.edu ========================================================================= Date: Fri, 12 Mar 1993 17:28:06 -0800 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Dmitry Serebrennikov Subject: Re: Microsoft Access - IIf function In-Reply-To: <9303120316.AA02960@nettlerash.berkeley.edu> from "Brian Keeler" at Mar 11, 93 03:57:18 pm > > line1 Brian Keeler Brian Keeler > line2 8403-44 avenue or 8403-44 avenue > line3 Apartment 201 > line4 Edmonton Alberta T6K0Z6 Edmonton Alberta T6K0Z6 > ... > > =IIf([address2]Is Null,"|[city]| |[province]| |[postalcode]|","[address2]") > I don't have a manual at my side right now, but isn't it IsNull([address1]) not [address2]Is Null? Also I am not familiar with "|[field]| |[field]|..." sintax. I've seen here people refer to it, but I havn't used it yet. It seems strange though, that you need to put it in ""... ,spacially the "[address]" stuff. Hope this doesn't destruct you and maybe helps... ---------------------------------------------------------------------------- Dmitry Serebrennikov dmitry@ucsee.berkeley.edu ========================================================================= Date: Mon, 15 Mar 1993 10:50:42 GMT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Brian J Read Datab" Subject: Microsoft Access - IIf function *** Reply to note of 15/03/93 09:07 BJR@UK.AC.RL.IB SERC RAL CCD SDD R27.G22 0235-44-6492 --------------------------------------------------------------- ,lf access Is it necessary to put each line of the address in a separate field given that ACCESS allows multiline field values? --------------------------------------------------------------- ========================================================================= Date: Mon, 15 Mar 1993 08:38:37 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Rickey Thomas Tom Subject: case sensitive Does anyone know how case sensitivity can be enforced in ACCESS. It appears that (for example) "Id" == "ID" == "iD". Although the user will unlikely have two keywords that differ only by case sensitivity. This is unacceptable. I don't want to convert them all to lower or to upper case. The problem is clear when data is imported into ACCESS and the data is exported to a C program. rick ========================================================================= Date: Mon, 15 Mar 1993 09:50:25 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Nathan Brindle" Subject: European Access List I've had a couple of requests for the address of the European Access list. It is: MS-ACCESS@EUNET.CO.AT Remember, I will be linking the two lists this evening, so subscribers to both lists will have to put up with some duplicate mail. Nathan Brindle Listowner -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 15 Mar 1993 09:22:30 -0800 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Dmitry Serebrennikov Subject: Re: European Access List In-Reply-To: <9303151450.AA17483@nettlerash.berkeley.edu> from "Nathan Brindle" at Mar 15, 93 09:50:25 am > > I've had a couple of requests for the address of the European Access > list. It is: > > MS-ACCESS@EUNET.CO.AT > > Remember, I will be linking the two lists this evening, so subscribers > to both lists will have to put up with some duplicate mail. I am sorry, I am unclear on this: do you mean that being a subscriber of this (American) list I will also get the posts from the Euro list, or is only when I am the Euro subscriber I will be getting posts from here and Euro? I.e. is the link you are going to make bidirectional? dmitry serebrennikov dmitry@ucsee.berkeley.edu ========================================================================= Date: Mon, 15 Mar 1993 10:55:21 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Jim Renaud Subject: Source and Destination for controls? I've tried to post this before, but had trouble doing so. If you've seen this one before, then just ignore this one. I'm trying to define a control that does 2 things. It updates a field in the underlying table (this control resides on a form). Also, the control's value is determined by summing the records in a related table. >From what I can tell, Access gives me a property called "source" that it uses to dispaly/update from an underlying table or query. The problem is that I want separate source and destination properties. I want the source to be a dsum() function. That way, the user will see the form control having the correct value. Also, I want to have a destination property that allows that value (from the source) to be stored in the field of the underlying table. I have tried making the source of the control the dsum function. But, of course it did not update underlying table. If you want to know specifically what I'm doing, read on... I have a PurchaseOrders form with a POItems subform attached to it. One of the controls on the POItems subform is a Quantity field. The Quantity field refers to the total quantity of the specific item that has been ordered. To make it interesting, if the user clicks on Quantity (or tries to enter the field) another form pops up with more information on this PO item. It shows each individual Sales Order that has at least one of these items ordered (that should be applied to this Purchase Order). For example, I can have Quantity 10 of item XYZ on the PO. These 10 can be composed of 2 Sales Orders of 5 each (or any combination). Anyway, I want the Quantity field on the PurchaseOrder form to reflect the total Quantity of this particular item (for each Sales Order that applies). In this case it is 10. I have everything working fine except that I can't get the control on the PurchaseOrders form to show the correct total. Using dsum() as the source for this control seems to sum the values correctly, but the underlying table does not get updated. I have thought of having one of the update properties of the pop-up form update the PurchaseOrders form whenever the user updates the data in the pop-up. That's not so bad, but I think it is error prone and redundant because I would need a similar procedure for each field (of each form) that might need this kind of update. I think Access should have separate source and destination for each control. Is there some better way to do this or should we have separate source and destination for controls? ----------------------------------------------------------------------- Jim Renaud [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-992-2662 Bldg. M3 Room 235 Fax: 408-773-0833 1230 E. Arques Avenue Email: wiseguy@mcode.amdahl.com Sunnyvale, CA 94088-3470 ========================================================================= Date: Mon, 15 Mar 1993 14:16:47 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Nathan Brindle" Subject: Re: European Access List In-Reply-To: Message of Mon, 15 Mar 1993 09:22:30 -0800 from OK, In order to clarify: The link between ACCESS-L and MS-ACCESS is in one direction only. MS-ACCESS will be subscribed to ACCESS-L and will distribute ACCESS-L traffic to its own subscribers. MS-ACCESS traffic will not normally come to ACCESS-L unless a user there either a) replies to an ACCESS-L posting or b) cc's his MS-ACCESS posting to ACCESS-L. Think of this as a join between ACCESS-L and MS-ACCESS where the result is: If you are an ACCESS-L subscriber you receive ACCESS-L mail only. If you are an MS-ACCESS subscriber you receive BOTH. Hope this helps. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 15 Mar 1993 14:21:41 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Nathan Brindle" Subject: Re: European Access List In-Reply-To: Message of Mon, 15 Mar 1993 09:22:30 -0800 from It just occurred to me that MS-ACCESS could be viewed as a local mail exploder that subscribes to ACCESS-L (and there are several of those at present) and works much the same way. Just as we don't receive local mail from people behind the mail exploders, we just won't receive original MS-ACCESS mail unless someone cc's or replies to us. Sorry to take up bandwidth but I want to make sure everyone understands this process. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 15 Mar 1993 15:24:27 CST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Brian M. Glasgow" Subject: Re: Runtime licensing for Access > Date: Fri, 12 Mar 1993 17:19:21 -0800 > Reply-to: > "Microsoft Access Database Discussion List" > From: Dmitry Serebrennikov > Subject: Re: Runtime licensing for Access > X-To: ACCESS-L%INDYCMS.BITNET@cmsa.Berkeley.EDU > To: Multiple recipients of list ACCESS-L > > > > Can anyone give me information concerning a Run_time License for MS- > > Access. (AKA Added Value reseller packaging) I have developed a few > > > Along the simular lines: has anyone heard of a compiler for ACCESS? > I heard that it is being developed, but I don't know if that's true. >In answer to my own question about Run-Time Licensing, I contacted MicroSoft and was informed that an "Access Developers Kit" would be released about May 1, 1993. No price given. ========================================================================= Date: Mon, 15 Mar 1993 15:41:10 CST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Brad Hartmann Subject: EUROPEAN ADDRESS I acccidently deleted the European address. Would somebody please e- mail it to me personaly so we don't unnecessarily use the net for something already sent. Thanks in advance! ============================================================================= Brad Hartmann University Of Missouri Network Manager College Of Veterinary Medicine VMBRADH@VETMED.VETMED.MISSOURI.EDU Columbia Missouri PHONE: (314) 882-1883 FAX: (314) 882=2950 ============================================================================= ========================================================================= Date: Mon, 15 Mar 1993 16:58:05 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Nathan Brindle" Subject: Re: Runtime licensing for Access In-Reply-To: Message of Mon, 15 Mar 1993 15:24:27 CST from I attended a Microsoft seminar on Access and Windows back in January and at that time, the presentor responded to the question of an Access run-time by saying "some time late in the spring or early in the summer" and that it would LIST at around $495. This elicited many groans from the audience. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Tue, 16 Mar 1993 13:34:06 MET Reply-To: chytil@vlsivie.tuwien.ac.at Sender: "Microsoft Access Database Discussion List" From: Chytil Georg Subject: test : please ignore Sorry folks : Testing the "reply to access-l"-feature of ms-access@eunet.co.at . Users subscribed to both lists should get this message twice --like me . Georg <-------Trust not a man who's rich in flax, his morals may be sadly lax-------> Chytil Georg Ex-Systemdamager@Dep. of VLSI (vlsivie) TU Wien 1040 Wien Austria chytil@vlsivie.tuwien.ac.at +43/222/3718445 #include Don't panic! Fax: +43/(0)222/569697 ========================================================================= Date: Tue, 16 Mar 1993 13:01:57 CST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Arthur B. Smith" Subject: Distribution Kit (Runtime license) Talking to Microsoft, I hear that the Distribution Kit for ACCESS will be available May 1. An announcement will be sent to all registered users of ACCESS concerning it, but I was told it would be a separate product which would allow you to turn applications developed under ACCESS into stand-alone applications that could then be distributed royaltee-free. In the most recent catalog (received yesterday) from PC ZONE, they already list the ACESS Distribution Kit for $314. Now y'all know as much about it as I do. Hope that helps! -art ------------------------------ 8^) ----------------------------------- Arthur B. Smith art@vets.vetmed.missouri.edu Dept. of Vet. Med. & Surg. (314) 882-2666 (voice) A-353 Clydesdale Hall (314) 884-5444 (FAX) University of Missouri (314) 642-4768 (Home) Columbia, MO 65211 Usual disclaimers apply! ========================================================================= Date: Wed, 17 Mar 1993 10:51:01 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Nathan Brindle" Subject: subs to MS-ACCESS Georg Chytil has asked me to relay to ACCESS-L subscribers the information that subscription requests for MS-ACCESS should be sent to: MS-ACCESS-REQUEST@EUNET.CO.AT If you send them to MS-ACCESS, they just get distributed to the list. Thanks, Nathan Brindle Listowner -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Wed, 17 Mar 1993 16:53:00 +0100 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: MARTIN@HSEPM1.HSE.NL Subject: Macro condition probs Dear collegues, W've recently started working with Access, primarily as a replacement for buggy dBFast. We developed a signature-administration in dBFast and I succeeded in transferring all data, although the pictures had to be done one-by-one via the clipboard. I'm experimenting with Access, trying to recreate the old work-environment we had, also trying to avoid programming in Access Basic, for I want to know how much can be done without programming. The problem I currently have is the following: When in a certain Form, I want to be able to activate a Button wich has a specific Macro attached. This Macro should test if the current record is either the last (or the first) record. I don't seem to be able to use the DFirst, EOF and First functions here, so how can I do it then? (I tried them but failed) Martin Ederveen, Hogeschool Eindhoven, The Netherlands MARTIN@HSE.NL ========================================================================= Date: Wed, 17 Mar 1993 13:44:44 -0600 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Bob Hambuchen Subject: Access Advisor Magazine Today I received a card advertising a new magazine for Access users. It is called Access Advisor and sells for $29 per year (6 issues). The phone number is 800-336-6060 in USA, 619-483-6400 outside USA and 619-483-9851 for FAX. I have no connection with this company, nor do I recommend the magazine. I merely pass this along to anyone who may be interested. Cheers! Bob Hambuchen bob@winrock.org ========================================================================= Date: Wed, 17 Mar 1993 16:47:54 -0800 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Dmitry Serebrennikov Subject: Re: Source and Destination for controls? In-Reply-To: <9303152113.AA29689@nettlerash.berkeley.edu> from "Jim Renaud" at Mar 15, 93 10:55:21 am > I'm trying to define a control that does 2 things. It updates a field in > the underlying table (this control resides on a form). Also, the control's > value is determined by summing the records in a related table. > > >From what I can tell, Access gives me a property called "source" that it > uses to dispaly/update from an underlying table or query. The problem is that > I want separate source and destination properties. I want the source > to be a dsum() function. That way, the user will see the form control having > the correct value. Also, I want to have a destination property that allows > that value (from the source) to be stored in the field of the underlying table. Make the control either unbound or calculated (dsum function or whatever in the source property), then try assigning a macro to the before update property -- that may let you intersept Access and not comeback to you with "Controll is calculated" in the message bar. Other then that you can try some combination of two controlls one on top of another and setting one to invisible, unless the focus is on the (calculated) control. When you put focus onto the calculated control your macro should take over and swap the controls from under the user, so that you will actually change the real control. Hope this helps. Dmitry Serebrennikov at dmitry@ucsee.berkeley.edu ========================================================================= Date: Thu, 18 Mar 1993 10:06:59 GMT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Anne L Zorner R27.G5/" Subject: Is there a Microsoft SQL Server list? + other questions SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB =============================================================== Does anyone know of such a list please? Are any of you using Access to access microsoft SQL Server, or any other SQL server? Is anyone writing any ODBC interfaces to databases such as SQL/DS on VM or VSE? Anne Thankyou =============================================================== ========================================================================= Date: Thu, 18 Mar 1993 14:57:15 GMT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Anne L Zorner R27.G5/" Subject: Is it necessary to write programs in Access? SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB =============================================================== Dear all I have been reading the mail from this list with much interest as a relatively new user to access. Thanks to one bit of mail we eventually found out how to get labels out! However what I dont understand is why there seems to be so much programming going on? Is there really so much going on or is it that others have found the way to get the forms and report code out as code after haveing used the point and click interface. What I would really like to know is what do people feel are the limitations of Access such that programming forms and reports is necessary? Regards Anne Thankyou =============================================================== ========================================================================= Date: Thu, 18 Mar 1993 10:47:11 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Jim Renaud Subject: Re: Is it necessary to write programs in Access? I have found that Access requires some amount of programming either through macros or Access Basic to do realistic forms/reports. One example I have is that I have an order form that uses a combo box to select the customer. On the order form are some text controls that display the customer address, phone, etc. The form is based on a query that has the Order table and Customer table joined (and other tables, also). When I open the form, the form correctly showed that the customer name (default in the combo box) matched the information in the text controls about that customer. The problem was that if I selected a different customer through the combo box, the associated customer data on the form did not get updated to match the newly selected customer. The other text controls still had the previous customer information. Minimally, you would have to have a macro (or module) that could do a requery or refresh on the "before update" property of the customer combo box control. I did not have good luck with either of these (did not seem to work right) so I ended up having a routine (access basic) that updated each control on the form by looking up the information in the Customers table. I think Access should do this automatically for me without having to write any macro. Since Access knows that both the Order table and Customer table are related, if I change the customer (CustomerNumber) on the form, it should automatically update the other related customer data that is on the form. [The tables are related with CustomerNumber field] Some people might consider this a nit because it is still alot easier than what we used to do with either Dbase or Clipper. But, it could be alot better. There are more of these that I (and others) have seen. Maybe Microsoft is reading this... ----------------------------------------------------------------------- Jim Renaud [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-992-2662 Bldg. M3 Room 235 Fax: 408-773-0833 1230 E. Arques Avenue Email: wiseguy@mcode.amdahl.com Sunnyvale, CA 94088-3470 ========================================================================= Date: Thu, 18 Mar 1993 14:03:23 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Nathan Brindle" Subject: Re: Is it necessary to write programs in Access? In-Reply-To: Message of Thu, 18 Mar 1993 10:47:11 PST from I'm going to take a wild stab here...but did you use a form and a subform setup, where the main form would hold customer data and the subform would hold order data based on a query? I have a form/subform set up that works rather well without any macros, which displays the name of a service project and other project-related information from the PROJECTS table in the main form, and the name, member number, date, and hours worked for each member in the subform (which is based on a query to a SERVICE HOURS table which has a record for each member on each project. I don't feel like I'm describing this well, but it works very nicely for me. BTW, I pull the member's name out of a third table, APO, and the relationships between the three are like this: Table APO Table SERVICE HOURS Table PROJECTS Member Number -----------> Member Number (Member Data) Project Number <---------- Project Number (Date, Hours (Project Data) Worked, etc.) As you can see, SERVICE HOURS really contains the nitty gritty, and it's updated via a query. My form looks a lot like an invoice, with the main form in form view and the subform in datasheet view. I can page through projects by using the record arrows on the main form, or skim through members who worked individual projects by using the record arrows on the subform. I'll admit I had to mess about with this a little to make it work, but the upshot was that I had to read the manual and didn't need any macros. I tried at first to make it work on a single form and couldn't do it-- because I was having the same problem you describe. Hope this helps, -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Thu, 18 Mar 1993 15:47:58 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Jeff 603/881-0494 Subject: Re: Is it necessary to write programs in Access? If I've replied to the incorrect account, my apologies. Observation from my limited experience with Access is that the more you want to do with it, the more likely you are to at least use/need macros and perhaps some functions. Jim Renaud, if I understand your description of the order form you've developed, I believe that there's a simpler solution to the updates that you might want to try using macros. I've been working on a similar application and here's what I've come up with: For the Customer Name, use a unbounded combo box based on a Query of the Customer table (i.e., the properties for the combo box would have nothing for the control source, the Control Name something like CName and the Row Source would be the name of the customer file query). The rest of the Customer attribute text boxes would still be based on the query you already have developed. Within that query in the column where you've selected the Customer Name, enter the following on the criteria line =forms![Myform]![CName] Then create a macro whose sole function is requery. Attach this macro, I'll call it General.Name to the AfterUpdate of the Name combo box. jeff ========================================================================= Date: Thu, 18 Mar 1993 21:09:25 GMT Reply-To: dadams@dstrike.demon.co.uk Sender: "Microsoft Access Database Discussion List" From: David Adams Subject: Re: Macro condition probs In message <9303171955.aa19023@demon.demon.co.uk> you write: > > > The problem I currently have is the following: > When in a certain Form, I want to be able to activate a Button wich has > a specific Macro attached. This Macro should test if the current record > is either the last (or the first) record. > I don't seem to be able to use the DFirst, EOF and First functions here, > so how can I do it then? (I tried them but failed) Why not use the DFirst and DLast function, assuming you have a unique field in the table on which the form is based (a primary key)? Use a macro condition thus: DFirst("unique_field","table_or_query_on_which_form_is_ based")=forms!form_name!unique_field will be true for the first record in the table. ========================================================================= Date: Thu, 18 Mar 1993 15:40:06 CST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: randy legeai Subject: Mailing Label Problem on DMP Having recently purchased Access, the first thing I did was to import a simple dbase file and create a mailing label form with the formwizard. Since there's a Panasonic kxp1180 attached to my computer, I selected it for output and picked the appropriate Avery label (4145). This is a simple single-column form-feed label for my simple dot-matrix printer. I formatted the text as Courier-12cpi (standard). Imagine my dismay to see a page preview that showed only 11 labels on a page (there are 12 labels per 'page' on standard 3.5 x 15/16" label sheets). In addition, the top of the first line of the first label is missing! To make matters worse, the Design view shows a label that is exactly the correct size, with the text perfectly placed! The margin settings in Setup looked OK. I've spent quite a bit of time trying other margin settings, page sizes, labels, and even different printer drivers, all with the same/similar result. What am I missing here?? Surely Access can print simple 1-across labels on a standard dot-matrix printer. Has anyone had a similar experience? Any suggestions would be greatly appreciated. I would hate to have to write code just to print such simple labels! -- Randall Legeai rlegeai@rs1.tcs.tulane.edu Federal Agency Affairs / Ctr. Bioenv. Research Phn: 504/865-5758 327 Gibson Hall, Tulane University Fax: 504/865-5274 New Orleans, Louisiana 70118-5698 ========================================================================= Date: Thu, 18 Mar 1993 21:21:05 GMT Reply-To: dadams@dstrike.demon.co.uk Sender: "Microsoft Access Database Discussion List" From: David Adams Subject: Re: Source and Destination for controls? In message <9303180317.aa20734@demon.demon.co.uk> you write: > > > I'm trying to define a control that does 2 things. It updates a field in > > the underlying table (this control resides on a form). Also, the control's > > value is determined by summing the records in a related table. > > > > >From what I can tell, Access gives me a property called "source" that it > > uses to dispaly/update from an underlying table or query. The problem is that > > I want separate source and destination properties. I want the source > > to be a dsum() function. That way, the user will see the form control having > > the correct value. Also, I want to have a destination property that allows > > that value (from the source) to be stored in the field of the underlying > table. > Make the control either unbound or calculated (dsum function or whatever > in the source property), then try assigning a macro to the before > update property -- that may let you intersept Access and not comeback > to you with "Controll is calculated" in the message bar. > Other then that you can try some combination of two controlls one on top > of another and setting one to invisible, unless the focus is on the > (calculated) control. When you put focus onto the calculated control > your macro should take over and swap the controls from under the user, > so that you will actually change the real control. > Perhaps I am missing something here, but surely this would work: Set the OnInsert (or OnCurrent if you want the value updated every time you look at the record) property to =my_func() Then define a module function thus: Function my_func () forms![Your_Form]![Your_field] = dSum(whatever) End Function Come to think of it, you could also use a macro, with a single line: SetValue, forms![Your_form]![Your_field], dsum(whatever) ========================================================================= Date: Thu, 18 Mar 1993 15:58:46 CST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Joseph Wu Subject: object oriented database in C++ I would like to know more about Object oriented database in C++ and if you have information about the books, or FTP sites which might help my study, please drop me a mail!!! Thanks ========================================================================= Date: Thu, 18 Mar 1993 14:45:46 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Jim Renaud Subject: Re: Is it necessary to write programs in Access? > > Jim Renaud, if I understand your description of the order form you've developed, > I believe that there's a simpler solution to the updates that you might want to > try using macros. I've been working on a similar application and here's what > I've come up with: > > For the Customer Name, use a unbounded combo box based on a Query of the > Customer table (i.e., the properties for the combo box would have nothing for > the control source, the Control Name something like CName and the Row Source > would be the name of the customer file query). > > The rest of the Customer attribute text boxes would still be based on the query > you already have developed. Within that query in the column where you've > selected the Customer Name, enter the following on the criteria line > =forms![Myform]![CName] > > Then create a macro whose sole function is requery. Attach this macro, I'll call > it General.Name to the AfterUpdate of the Name combo box. > > > jeff > Hmmm....it seems like the criteria is the only thing I was missing the first time I attempted to do this. I had everything else you suggested. We'll see if that works. [The problem with me is that I'm used to programming these types of apps using dbase, clipper, or c. So, when I get frustrated with Access, I tend to fix it with code.] Thanks for the suggestion, ----------------------------------------------------------------------- Jim Renaud [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-992-2662 Bldg. M3 Room 235 Fax: 408-773-0833 1230 E. Arques Avenue Email: wiseguy@mcode.amdahl.com Sunnyvale, CA 94088-3470 ========================================================================= Date: Thu, 18 Mar 1993 15:15:13 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Jim Renaud Subject: Re: Source and Destination for controls? > Perhaps I am missing something here, but surely this would work: > Set the OnInsert (or OnCurrent if you want the value updated every time you > look at the record) property to > =my_func() > > Then define a module function thus: > Function my_func () > forms![Your_Form]![Your_field] = dSum(whatever) > End Function > > Come to think of it, you could also use a macro, with a single line: > SetValue, forms![Your_form]![Your_field], dsum(whatever) > No, you are not missing anything. I'll have to try this all again, but I received an error using your second option when I tried it before. But, I did not do this using OnCurrent of that record, I used the AfterUpdate property of the pop up form. In other words I was updating (trying to, anyway) the main form from the pop up form whenever a Quantity changed. Although I was using the long form notation, there was an error using dsum in this manner. I will try this again and post the results. Thanks for your suggestions. ----------------------------------------------------------------------- Jim Renaud [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-992-2662 Bldg. M3 Room 235 Fax: 408-773-0833 1230 E. Arques Avenue Email: wiseguy@mcode.amdahl.com Sunnyvale, CA 94088-3470 ========================================================================= Date: Thu, 18 Mar 1993 16:15:22 -0800 Reply-To: ACCESS-L%INDYCMS.BITNET@pucc.Princeton.EDU Sender: "Microsoft Access Database Discussion List" Comments: E: RFC822 "local part" (username) containing a blank was encountered. These usernames are not presently supported. From: Undetermined origin c/o Postmaster Subject: Re: Is it necessary to write programs in Access? In-Reply-To: Your message of Thu, 18 Mar 93 14:03:23 -0500. Of the several applications I've built so far, I've not yet found one that did not require at least some macro or module coding in order to define a satisfactory interface. A typical example is my phone/address database: In this application I have two tables, one containing per person information (first name, last name, work phone, birthday, etc.) and the other containing address information (zip code, address, city, state, etc.). This structure was chosen to allow multiple "persons" to share a single "address" record, but therein lies its problem. These tables have a one-to-many relationship from address to person, but the query and form that unites them for editing sorts on person. When I constructed the form based on a query that joins a person record with an address record via an address-id field stored with the person, I was able to view and edit the combined data for any existing record. However, if I tried to add a new record to the form, new records would be created in the Person and Address tables, but the Person field that would provide the link to the new Address record would be left #NULL#. I spent days trying to find a way within the form, and then a way using macros, that would allow me to automatically set that field. What I finally developed was the following ABF: Function linkNameAddr() Dim ds As Database, n As Table, a As Table Set ds = CurrentDB() set n = ds.OpenTable("Name") n.MoveLast If IsNull(n.ADR) Then Set a = ds.OpenTable("Address") a.MoveLast n.Edit n.ADR = a.ADR n.Update End If End Function ________________________________________________________________________________ Robert Reed Home Animation Ltd. 503-656-8414 robert@slipknot.rain.com 5686 First Court, West Linn, OR 97068 The geographical center of Boston is in Roxbury. Due north of the center we find the South End. This is not to be confused with South Boston which lies directly east from the South End. North of the South End is East Boston and southwest of East Boston is the North End. ________________________________________________________________________________ ========================================================================= Date: Thu, 18 Mar 1993 16:28:46 -0800 Reply-To: ACCESS-L%INDYCMS.BITNET@pucc.Princeton.EDU Sender: "Microsoft Access Database Discussion List" From: robert@SLIPKNOT.RAIN.COM Subject: Re: Is it necessary to write programs in Access? In-Reply-To: Your message of Thu, 18 Mar 93 14:03:23 -0500. Of the several applications I've built so far, I've not yet found one that did not require at least some macro or module coding in order to define a satisfactory interface. A typical example is my phone/address database: In this application I have two tables, one containing per person information (first name, last name, work phone, birthday, etc.) and the other containing address information (zip code, address, city, state, etc.). This structure was chosen to allow multiple "persons" to share a single "address" record, but therein lies its problem. These tables have a one-to-many relationship from address to person, but the query and form that unites them for editing sorts on person. When I constructed the form based on a query that joins a person record with an address record via an address-id field stored with the person, I was able to view and edit the combined data for any existing record. However, if I tried to add a new record to the form, new records would be created in the Person and Address tables, but the Person field that would provide the link to the new Address record would be left #NULL#. I spent days trying to find a way within the form, and then a way using macros, that would allow me to automatically set that field. What I finally developed was the following ABF: Function linkNameAddr() Dim ds As Database, n As Table, a As Table Set ds = CurrentDB() set n = ds.OpenTable("Name") n.MoveLast If IsNull(n.ADR) Then Set a = ds.OpenTable("Address") a.MoveLast n.Edit n.ADR = a.ADR n.Update End If End Function ________________________________________________________________________________ Robert Reed Home Animation Ltd. 503-656-8414 robert@slipknot.rain.com 5686 First Court, West Linn, OR 97068 I wish there was a knob on the TV that would turn up the intelligence. There's one marked brightness, but it don't work, does it? --Gallagher ________________________________________________________________________________ ________________________________________________________________________________ Robert Reed Home Animation Ltd. 503-656-8414 robert@slipknot.rain.com 5686 First Court, West Linn, OR 97068 Why do they call them apartments when they're all stuck together --Gallagher ________________________________________________________________________________ ========================================================================= Date: Thu, 18 Mar 1993 20:09:21 -0800 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Dmitry Serebrennikov Subject: : Form/Subform with triple relationship In-Reply-To: <9303181911.AA16701@nettlerash.berkeley.edu> from "Nathan Brindle" at Mar 18, 93 02:03:23 pm > I have a form/subform set up that works > rather well without any macros, which displays the name of a service project > and other project-related information from the PROJECTS table in the main > form, and the name, member number, date, and hours worked for each member > in the subform (which is based on a query to a SERVICE HOURS table which > has a record for each member on each project. I don't feel like I'm > describing this well, but it works very nicely for me. BTW, I pull the > member's name out of a third table, APO, and the relationships between > the three are like this: > > Table APO Table SERVICE HOURS Table PROJECTS > Member Number -----------> Member Number > (Member Data) Project Number <---------- Project Number > (Date, Hours (Project Data) > Worked, etc.) > So your subform is based on a query from what I understand? I had a simular setup, but I am not too satisfied with the speed. Now, I don't know if you've seen this, but when I create a form with a subform on a related table, then the update in the subform is done by Access very fast indeed, much faster then if I wrote an SQL query (or QBE for that matter). Some how Access keeps track of positions in the related tables, and that makes sence. What does not work, is when I try to stik in the subform something like "Member Name" using your example (i.e. reference to another table also related but to the subform). I can put a subform in a subform, and that works well, but that requires the original subform to be in a single form view, and I'd like in in continious form view. My question to you all is do you know how Access is able to update the subform so fast and is there a way that I can get to the same mechanism by writing a program or a query? Thanks. Dmtiry Serebrennikov dmitry@ucsee.berkeley.edu ------------------------------------------------------------------------ Damn, why won't elm see my .signature file, so I don't need to type this in every time?!?!?! ========================================================================= Date: Fri, 19 Mar 1993 11:23:22 +0100 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: MARTIN@HSEPM1.HSE.NL Subject: Still the macro condition problem About the condition problems within the macro. David Adams wrote me a reply, wich I tested of course: >> >> The problem I currently have is the following: >> When in a certain Form, I want to be able to activate a Button wich has >> a specific Macro attached. This Macro should test if the current record >> is either the last (or the first) record. >> I don't seem to be able to use the DFirst, EOF and First functions here, >> so how can I do it then? (I tried them but failed) > >Why not use the DFirst and DLast function, assuming you have a unique field >in the table on which the form is based (a primary key)? Use a macro >condition thus: DFirst("unique_field","table_or_query_on_which_form_is_ >based")=forms!form_name!unique_field will be true for the first record >in the table. > I already tried DFirst, but not with the primary key, but this was easily done. I got a query named Personq on wich the form Pgeg is based, the orginal table is named Personnel. The macro has the name macro1 (original eh?). The field Pnumber is the primary key of the table. I used the following syntax: DFirst("Pnumber","Personq")=Forms!Pgeg!Pnumber I get an error: Can't parse expression! Actually this is again and again the same error I seem to get when trying to use DFirst in the macro condition. A function like First is obviously parsed well: First([Pnumber])=[Pnumber] But then I get an error when using the macro in the form: Function isn't available in expressions! These same things happen exactly with all the other things I tried: either I get a parse error OR later an unavailable error. *sigh* What am I doing wrong here? Martin Ederveen ------------------------------------------------------------------------------- | ing. Martin W. Ederveen | "In the future there will be real | | Hogeschool Eindhoven | thinking machines. | | Rachelsmolen 1 | Yes, but who's thoughts will they | | 5612 MA Eindhoven | be thinking?" | | tel. +31 (40) 605 262 | | | MARTIN@HSEPM1.HSE.NL | Quotation from Dr.Who: The Curse | | SURF017@KUB.NL | of Fenric | ------------------------------------------------------------------------------- ========================================================================= Date: Fri, 19 Mar 1993 21:32:47 GMT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Anne L Zorner R27.G5/" Subject: I had though that Access supported the concept of NULLs SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB =============================================================== Dear all When I create a table I want to be able to speficy that a partcular column does not allow NULLs, I do not want to leave this important aspect of database design to a FORM, can I do it. It is an important aspect of ANSI/ISO SQL. The more that I look at Access the less I feel that it embodies the spirit of the standard and the more that it seems to embody just a cloak of the standard. Normally to say that siomething supports a standard then it must pass at least the FIPS 127 test. I feel very sorry that after some 7 years of existance of the SQL 86 document that we are in this state. I was also dissapointed to find that I could not use SQL language to create a table. This makes life very difficult when say one has over 70 columns in a table and the definition of the create statement already exists in an ascii file, because one is just reprodcueing what one has in another database system on another platform. Anne Thankyou =============================================================== ========================================================================= Date: Fri, 19 Mar 1993 21:24:39 GMT Reply-To: dadams@dstrike.demon.co.uk Sender: "Microsoft Access Database Discussion List" From: David Adams Subject: Re: Still the macro condition problem In message <9303191031.aa06022@demon.demon.co.uk> you write: > I got a query named Personq on wich the form Pgeg is based, the orginal > table is named Personnel. The macro has the name macro1 (original eh?). > The field Pnumber is the primary key of the table. > > I used the following syntax: > > DFirst("Pnumber","Personq")=Forms!Pgeg!Pnumber > > I get an error: Can't parse expression! Firstly: Are you sure you entered *exactly* what you show above? Missing one of the quotes, using a name with a space with the [ and ] or misplacing an ! would all cause the problem, but it happily took the above line when I tried it. Secondly: You should use the dfirst function on the domain of the table, not the form. (You want to check if a record is the first in the table. Remember, DFirst will return the first record as given by the order of the records for the Primary Key.) > A function like First is obviously parsed well: > > First([Pnumber])=[Pnumber] > > But then I get an error when using the macro in the form: > Function isn't available in expressions! The function 'First' is only valid in certain places, as described in the help section, a macro condition is not one of them! Hope this helps. -- David Adams ========================================================================= Date: Fri, 19 Mar 1993 07:44:00 -0800 Reply-To: Tony Waddell Sender: "Microsoft Access Database Discussion List" From: Tony Waddell Subject: STILL THE MACRO CONDITION Please remove my name from the mailing list. I'm not currently working with MS ACCESS and find the information I'm receiving to be a bit overwhelming at the moment. Thanks, Tony Waddell ========================================================================= Date: Fri, 19 Mar 1993 15:48:06 -0800 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Dmitry Serebrennikov Subject: Re: I had though that Access supported the concept of NULLs In-Reply-To: <9303192144.AA14695@nettlesome.berkeley.edu> from "Anne L Zorner R27.G5/" at Mar 19, 93 09:32:47 pm > > I was also dissapointed to find that I could not use SQL language to > create a table. This makes life very difficult when say one has over 70 > columns in a table and the definition of the create statement already > exists in an ascii file, because one is just reprodcueing what one has > in another database system on another platform. Did you try to paste the SQL code into the View/SQL window in a Create Query? Or any query, I think the presents of the correct SQL sintax in that window will make any query into an Create query. Just a thought. Also, you could import the structure of your existing database (if you actually have one created) or maybe it would let you import it in some other form using different import options from the SQL definitions. I also came across of something you might like to know: in the View/ options menu choose General and set "Show system objects" to Yes. You will see a dozen of new tables show up in your tables menu. Try openning them and see what they are. Some of them it woun't let you to see, but others you can read, and I think they are some Access internals that actually store the queries and other info. I don't have much experience with SQL, but I think these tables will give you access to some of the things you are used to be using in the standard SQL environment (dates of table creation/updates, characteris tics of tables.) These system tables are just tables, and you can write Basic code that works with them and maybe even changes them. Moreover, I think that most of the "development tools" that are provided with Access as part of it (color pallete, macro editor, and other ugly things) are just forms that work with these tables. > Normally to say that siomething supports a standard then it must pass at > least the FIPS 127 test. I feel very sorry that after some 7 years of > existance of the SQL 86 document that we are in this state. Again not knowing the actual benefits of SQL standard I would still agree that Access is a idol of inconsistensy. There are, perhaps, five different syntaxies to call Basic functions, depending on what you do and where, plus you can't call the Subs! ------------------------------------------------------------------------------ Please, no flames -- I am using it and liking it, but what's true is true... ------------------------------------------------------------------------------ ========================================================================= Date: Sat, 20 Mar 1993 10:37:19 GMT Reply-To: dadams@dstrike.demon.co.uk Sender: "Microsoft Access Database Discussion List" From: David Adams Subject: Re: I had though that Access supported the concept of NULLs In message <9303192323.aa10805@demon.demon.co.uk> you write: > > SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB > =============================================================== > Dear all > When I create a table I want to be able to speficy that a partcular column > does not allow NULLs, I do not want to leave this important aspect of database > design to a FORM, can I do it. It is an important aspect of ANSI/ISO SQL. > The more that I look at Access the less I feel that it embodies the spirit > of the standard and the more that it seems to embody just a cloak of the > standard. I have not found a way. The problem is that you can't specify record level validation at the table design stage, and this is what you would need to do for this type of thing. Specifying Not IsNull([Field_name]) won't work since it won't check the field if nothing is entered in it. You can perform record level validation on a form, but I know you don't want to (why?). > > Normally to say that siomething supports a standard then it must pass at > least the FIPS 127 test. I feel very sorry that after some 7 years of > existance of the SQL 86 document that we are in this state. Indeed it is a unfortunate situation. However, while standards are important so is development and conforming to existing standards often holds us back in a lot of ways (take the IBM PC as an example). Furthermore, it isn't as though Access doesn't provide a mechanism for what you are trying to do, it is just that it's different from what you are used to, albeit that what you want is part of a 'standard'. This reminds me of an interesting article in a recent issue .EXE magazine which talks about the idioms of programming languages. The main thrust of the article is that we should embrace what a language has to offer... Having said all that, the ability to define record level validation at the table definition stage would be a plus and if Microsoft what to have the best product then they should implement it. > > I was also dissapointed to find that I could not use SQL language to > create a table. This makes life very difficult when say one has over 70 > columns in a table and the definition of the create statement already > exists in an ascii file, because one is just reprodcueing what one has > in another database system on another platform. You could enter SQL insert table code in the View SQL window of a query, if your existing ascii file is a complete SQL statement that Access will understand. However, you can't specify the exact field details, (such as field length or number type), just whether it is character,number, logical etc. Also you will get one record in the table. Secondly, it is possible to manipulate tables programmaticly from Access Basic, since their details are stored in the system table, MSysObjects. This would be a non trivial task - to make it flexible it would have to pass the ascii input file and be able to cope with whatever it found there. David Adams, Data Strike Computers Ltd. ========================================================================= Date: Sun, 21 Mar 1993 08:03:03 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Sunday EVERYDAY Subject: Re: subs to MS-ACCESS In-Reply-To: from "Nathan Brindle" at Mar 17, 93 10:51:01 am since you didn't say anything about UNsubs being sent here... here's mine.. unsubscribe me to this list. -jon madison ========================================================================= Date: Sun, 21 Mar 1993 13:56:20 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Nathan Brindle" Subject: Re: subs to MS-ACCESS In-Reply-To: Message of Sun, 21 Mar 1993 08:03:03 -0500 from OK, then I'll say it. :) If you wish to unsubscribe, please send the command UNSUB ACCESS-L to LISTSERV@INDYCMS.BITNET or LISTSERV@INDYCMS.IUPUI.EDU. Standard nettiquette requires that requests for list functions not be sent to the list (which does nothing for you) but to the ListServer, which will process your request. If trouble develops in trying to do something, you should send mail to the listowner (me) rather than to the list. Thank you. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 22 Mar 1993 10:57:09 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Pekka Koskinen CIMO Subject: Tab order Hello Access-users! I have some forms with quite a few fields, which I try to fit into one screen. So, there are several rows and columns of them. My problem is that the tab order never goes corectly (=left to right, top to bottom) without doing it manually ("custom order"). The "natural order" doesn't seem to work. Is there something I'm doing wrong or have I found a BUG? Thanks in advance! Pekka :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) _/_/_/_/ _/ _/_/ _/_/ _/_/_/_/ "Never try to teach a pig to sing. _/ _/ _/ _/ _/_/ _/ _/ _/ You will only lose your temper, _/ _/ _/ _/ _/ _/ and it frustrates the pig." _/ _/ _/ _/ _/ _/ _/ _/_/_/_/ _/ _/ _/ _/_/_/_/ Pekka Koskinen tel +358-(9)0-7747 7962 fax +358-(9)0-7747 7064 CIMO, P.O. Box 343, 00531 Helsinki, FINLAND ========================================================================= Date: Mon, 22 Mar 1993 11:50:04 GMT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Anne L Zorner R27.G5/" Subject: Nesting Queries SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB =============================================================== On p 508 of the Language Reference Manual it says subqueries; instead, you can nest multiple queries has anyone found any references to how one nests multiple queries in either the manuals or online help? I want to use correlated subqueries and want to see whether they can be done. example select a.x,a.y from table1 a where a.y not in (select b.y from table 2 where b.x=a.x) (note this is just a simplified example of what I want to do) Anne Thankyou =============================================================== ========================================================================= Date: Mon, 22 Mar 1993 11:56:10 GMT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Anne L Zorner R27.G5/" Subject: Variable length vs fixed length character strings SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB =============================================================== I want to be able to define that some columns allow variable length character strings and some must be fixed length. According to the standard this means that I want to use VARCHAR rather than CHAR. According to Accesses relationship to the standard it saysthat LONGTEXT is supported for VARCHAR but I dont seem to have the chnace to select LONG anything let alone TEXT from the allowed list of Datatypes in the Table Definition screen, have I got something missing? Anne Thankyou =============================================================== ========================================================================= Date: Sun, 21 Mar 1993 23:04:00 IST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Chezy Gal Subject: Can not install Access Hello, I'm having problems installing access on my pc. The install program tells me that I have not enough memory or disk space which is not true... I've got 8 MB ram and 30 MB free disk... What's happening...? Thanks, Chezy Gal Tel-Aviv University ========================================================================= Date: Mon, 22 Mar 1993 14:19:48 GMT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Anne L Zorner R27.G5/" Subject: re: create table and standards etc SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB =============================================================== >> >> I was also dissapointed to find that I could not use SQL language to >> create a table. This makes life very difficult when say one has over 70 >> columns in a table and the definition of the create statement already >> exists in an ascii file, because one is just reprodcueing what one has >> in another database system on another platform. > > Did you try to paste the SQL code into the View/SQL window in a > Create Query? Or any query, I think the presents of the correct > SQL sintax in that window will make any query into an Create > query. Just a thought. Pasteing does not work into the View/SQL Window, the Edit Menu option is not active at that point. There is no such thing as a CREATE Window except for creating a table from a query dataset. > > Also, you could import the structure of your existing database (if > you actually have one created) or maybe it would let you import it > in some other form using different import options from the SQL > definitions. There is no compatible format. SQL is the thing that should be used. > > I also came across of something you might like to know: in the View/ > options menu choose General and set "Show system objects" to Yes. > You will see a dozen of new tables show up in your tables menu. > Try openning them and see what they are. Some of them it woun't let > you to see, but others you can read, and I think they are some > Access internals that actually store the queries and other info. > I don't have much experience with SQL, but I think these tables will > give you access to some of the things you are used to be using in the > standard SQL environment (dates of table creation/updates, characteris > tics of tables.) Thankyou for that, indeed the MSysObjects does seem to have a list of all the tables as well as other things. I am not at the moment (I think) too worried as to whether these exist but I would be a little wary of writing any code against them, normally these tables are merely for information or system use, updating them directly (except for statistics adjustment ) would not be an action that I would recommend for any DBMS. > > These system tables are just tables, and you can write Basic code that > works with them and maybe even changes them. Moreover, I think that > most of the "development tools" that are provided with Access as part > of it (color pallete, macro editor, and other ugly things) are just > forms that work with these tables. > >> Normally to say that siomething supports a standard then it must pass at >> least the FIPS 127 test. I feel very sorry that after some 7 years of >> existance of the SQL 86 document that we are in this state. > > Again not knowing the actual benefits of SQL standard I would still > agree that Access is a idol of inconsistensy. There are, perhaps, > five different syntaxies to call Basic functions, depending on what > you do and where, plus you can't call the Subs! > Sadly (?) Basic is not standardised, but there does exist an SQL standard. One of its main benefits is that one can move a database from one platform to another and work out that the create table, select, update, delete statement will all work in the same way. If one used a standard language eg C then in the main that should all work as well. More importantly it allows people to use different products and still understand that what they are asking gives the same result. The more differences the more time it takes to learn about a new environment. Windows is an interesting example of a defacto standard. Its use by so many product suppliers has meant taht I find I can go to a new product and almost immediately find my way around it. Because MSAccess has deliberatly changed the meaning behind some of the relational terminologies (in order to comply with dbase) so it means that it is harder for relationally experienced users to use it. Anne Thankyou =============================================================== ========================================================================= Date: Mon, 22 Mar 1993 10:21:28 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Nathan Brindle" Subject: Re: Can not install Access In-Reply-To: Message of Sun, 21 Mar 1993 23:04:00 IST from Just a stab in the dark, but--are you running Windows in Standard or 386 Enhanced Mode? If Standard, get into the Control Panel and change it to 386 Enhanced. That might clear up the memory problem, since the two modes use memory differently. No guarantee that this will work, but it might be worth a try. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 22 Mar 1993 16:03:08 GMT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Anne L Zorner R27.G5/" Subject: Import/Export Setup Window SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB =============================================================== Why is that this window does not allow me to switch back to other windows in the access desktop? Since I can find no way of automatically getting my 75 columns names into my specification (yes I need them cos I'm importing from a fixed width file) I had hoped to use copy and paste on each column name . I can see that I should have started from the import spec to create the table but that does not seem obvious, normally one creates the table first and then loads in data (which may come from many sources. Anne Thankyou =============================================================== ========================================================================= Date: Mon, 22 Mar 1993 09:05:05 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: hchin@SFU.CA Subject: Re: Tab order In-Reply-To: <9303220911.AA18437@whistler.sfu.ca>; from "Pekka Koskinen CIMO" at Mar 22, 93 10:57 am > > I have some forms with quite a few fields, which I try to fit into one > screen. So, there are several rows and columns of them. > > My problem is that the tab order never goes corectly (=left to right, > top to bottom) without doing it manually ("custom order"). The "natural > order" doesn't seem to work. > I have asked this question about a while ago, there was no answer for this. I have found a "stupid " way of doing it. Try cut and paste in the order the you want. e.g. if you want your field to go in 1,2,3,4,5,6 order, then start cutting and pasting from field 1 , field 2 and .....so on. Fred chin ========================================================================= Date: Mon, 22 Mar 1993 09:18:11 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Jim Renaud Subject: Re: Strange Tables? > > When creating some reports out of a query I suddenly had some strange > tables in my list: > > They are all called MSysAces, MSysColumns, ... > > Seems as if they are internal Access-tables but why do I see them? > Because I've opened the table as Administrator? > > Any hints welcome > > Martin > > Try setting "Show system objects" to No in the "General" options (accessed via View menu, Options). ----------------------------------------------------------------------- Jim Renaud [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-992-2662 Bldg. M3 Room 235 Fax: 408-773-0833 1230 E. Arques Avenue Email: wiseguy@mcode.amdahl.com Sunnyvale, CA 94088-3470 ========================================================================= Date: Mon, 22 Mar 1993 09:26:34 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Jim Renaud Subject: Re: Tab order > > > > I have some forms with quite a few fields, which I try to fit into one > > screen. So, there are several rows and columns of them. > > > > My problem is that the tab order never goes corectly (=left to right, > > top to bottom) without doing it manually ("custom order"). The "natural > > order" doesn't seem to work. > > > > I have asked this question about a while ago, there was no answer for this. > I have found a "stupid " way of doing it. Try cut and paste in the order the > you want. e.g. if you want your field to go in 1,2,3,4,5,6 order, then start > cutting and pasting from field 1 , field 2 and .....so on. > > Fred chin > I don't have my PC in front of me, so I might be a little off here. I think the item you are looking for in on the Edit menu, "Tab Order" option. With the dialog that pops up, you can specify the exact order of fields. Hope this helps ----------------------------------------------------------------------- Jim Renaud [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-992-2662 Bldg. M3 Room 235 Fax: 408-773-0833 1230 E. Arques Avenue Email: wiseguy@mcode.amdahl.com Sunnyvale, CA 94088-3470 ========================================================================= Date: Mon, 22 Mar 1993 09:34:51 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Jerry Dunietz Subject: re: create table and standards etc Anne L Zorner writes: Pasteing does not work into the View/SQL Window, the Edit Menu option is not active at that point. There is no such thing as a CREATE Window except for creating a table from a query dataset. Note that although the main menu is not active when the View/SQL Window is up, the standard keyboard accelerators for cut/copy/paste are available in the View/SQL Window and other popup windows (like property sheets) in Access. Ctrl-X is cut, Ctrl-C is copy, and Ctrl-V is paste. Jerry J. Dunietz Any opinions expressed are my own, and not necessarily those of my employer. ========================================================================= Date: Mon, 22 Mar 1993 10:01:25 -0800 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Dmitry Serebrennikov Subject: Re: create table and standards etc In-Reply-To: <9303221424.AA03679@nettlerash.berkeley.edu> from "Anne L Zorner R27.G5/" at Mar 22, 93 02:19:48 pm > > Did you try to paste the SQL code into the View/SQL window in a > > Create Query? Or any query, I think the presents of the correct > > SQL sintax in that window will make any query into an Create > > query. Just a thought. > Pasteing does not work into the View/SQL Window, the Edit Menu option > is not active at that point. There is no such thing as a CREATE Window > except for creating a table from a query dataset. > > > > Also, you could import the structure of your existing database (if Try using the keyboard short cuts instead of the menu option, I think it worked for me (Ctrl+Ins), at least I am sure that you can actually type in that box! You right, though, if it supported the standard it would make life much easer for the developers who had a lot of experience with othe databases. Does MicroSoft SQL server support all the standards? There is an interface to it included with MS-Access package, and you can also import the data from that server, so if the things are really bad you might try to import /create your tables using that back door :) Good Luck, Dmitry dmitry@ucsee.berkeley.edu ========================================================================= Date: Mon, 22 Mar 1993 10:24:34 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Jim Renaud Subject: Re: Counter field problem > In a ACCESS table I have a date field as the primary key and a counter > field to generate a record identifier. I need the record numbers to be > in the same sequence as the as the date even though the records are not > entered in date sequence. Any ideas? As of now I have been unable to > get ACCESS to re-identify the records when a new record is entered and > its date places it in the middle of the table. The new record is > identified as the last record i.e. it has the highest id number. > > I need the identifier in sequence with the date so I can create a date > range in a query. In the query I use the date on the record as the > beginning of the date range and the date on the next record to identify > the ending date of the range. The next record is identified by adding 1 > to the current records id number. > Because Access controls updates to Counter fields so stringently, I only use Counter fields for tables that require an accessible number, but will not be displayed publicly (like on forms and such). I know others may not totally agree with me on that statement. For example, an Order table might be considered a good place to use a Counter field. This is because it makes it easier to increment the Order number (it's done automatically). Also, it makes certain that no duplicate Order numbers are ever used. The problem is that Access won't let you give a starting value for Counter fields (at least I don't know how). Some customers that I am developing this Access application for may not allow me to dictate what the Order number (or invoice number, ...) is going to be. They may be currently working a manual Order system and have already used thenumbers that the Counter would start with. I create a special table (call it Settings, SystemInfo, or whatever). This table has only one record. Then define a field in this table for the current OrderNumber, InvoiceNumber, etc. I have my own routine called NewOrderNumber() that locks the table, gets the current OrderNumber, increments the OrderNumber in the table, and finally unlocks the table. That way, your application can easily be changed for different OrderNumber starting values by setting that field to the correct number before the customer uses your system for the first time. Of course, if your system is only used in-house you might not want to go through the extra hassle I just described. Now what does all this have to do with your problem??? If you wanted, you could do the same procedure that I mentioned above. You could put the "NewOrderNumber()" (or whatever name you need) function call in the default value for the field that you are concerned about. BTW, I also put in my "Settings" table information such as "Name", "Address", and other pertinent information about the user of my database application. I reference these fields in forms and reports, so that I only have to change the values in the "Settings" table for other customers that want my application. ----------------------------------------------------------------------- Jim Renaud [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-992-2662 Bldg. M3 Room 235 Fax: 408-773-0833 1230 E. Arques Avenue Email: wiseguy@mcode.amdahl.com Sunnyvale, CA 94088-3470 ========================================================================= Date: Mon, 22 Mar 1993 11:30:48 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: RAM DIMBA Subject: Help on split transactions This might not be right band-width to ask the following question, since I am using Access, I thought I should try to get help from professional Access users. How do I split a transaction? For example, a single payment to a vendor may consist of cost of the product, applicable sales tax and the shipping charges. I would like to enter all these under one data entry form (Checks). I would appreciate any general ideas or any other suggestions. I am a novice programmer,so please do not laugh!!! Thanks in advance! Ram Dimba General Accounting Stanford University 857 Serra Street MC 6205 Stanford, CA 94305 email : ramd@forsythe.stanford.edu ========================================================================= Date: Mon, 22 Mar 1993 13:58:00 CST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: miguelr@IHLPE.ATT.COM Subject: One-to-Many Relationship I have a question to the Access experts: How can I include a field in a form that is the ONE side of a ONE-to-many relationship and be able to update the undelaying table? I understand how can I include a MANY-to-MANY subform. Thanks, Miguel A. Rivera AT&T Bell Labs. Naperville, IL. 60563 miguelr@ihlpe.att.com ========================================================================= Date: Mon, 22 Mar 1993 22:19:02 IST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Chezy Gal Subject: Re: Can not install Access In-Reply-To: Message of Mon, 22 Mar 1993 10:21:28 EST from On Mon, 22 Mar 1993 10:21:28 EST Nathan Brindle said: >Just a stab in the dark, but--are you running Windows in Standard or >386 Enhanced Mode? If Standard, get into the Control Panel and change >it to 386 Enhanced. That might clear up the memory problem, since the >two modes use memory differently. > >No guarantee that this will work, but it might be worth a try. > >-----------------------------------------------------BITNET: NBRINDLE@INDYCMS I'm running windows in enhanced mode, and using about 12MB more in virtual mem. Still it won't load. Any more sagestions...? help..? Thanks, Chezy Gal ========================================================================= Date: Mon, 22 Mar 1993 15:55:37 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Nathan Brindle" Subject: Re: Can not install Access In-Reply-To: Message of Mon, 22 Mar 1993 22:19:02 IST from OK, How far do you get in the installation process and what are the error messages that you get when Access will not install? Maybe that would provide a clue. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 22 Mar 1993 15:55:06 -0600 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: MARK TURPIN Subject: RE: I had though that Access supported the concept of NULLs It is possible to paste SQL in to a query. 1. While in Notepad, copy the SQL code to the Clip Board. 2. In Access create a new query 3. Select SQL View and then press Ctrl V. This will copy the SQL to the query. ========================================================================= Date: Mon, 22 Mar 1993 22:16:32 GMT Reply-To: dadams@dstrike.demon.co.uk Sender: "Microsoft Access Database Discussion List" From: David Adams Subject: Re: Nesting Queries In message <9303221155.aa28993@demon.demon.co.uk> you write: > > SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB > =============================================================== > On p 508 of the Language Reference Manual it says > > subqueries; instead, you can nest multiple queries > > has anyone found any references to how one nests multiple queries in either > the manuals or online help? > > I want to use correlated subqueries and want to see whether they can be done. > > > example > > select a.x,a.y from table1 a > where a.y not in (select b.y from table 2 > where b.x=a.x) I believe there isn't a way to nest queries using the query builder, or by entering SQL in the SQL box. You can get the result you need in one of two ways: Using the query builder: create a query, save it and then create another, 'adding' the first as the table (in fact, it is a query) from which to query. Running the second query will cause the first to be executed, then the second. Note however, that the first must be an updateable query, which means for one thing that it can't use parameters. The more flexible way is to do it under Access Basic. You can create a query which runs on a dynaset, which itself was the result of a query, that is use createdynaset, the first time using the database as the object, the second time the dynaset created by the first. If that was all good news (though I suspect it may not be), then here is the bad news. Access SQL does not support the In operator (the way you have used it), and more troublesomely (is that a word?!), the Not In construct. So to acheive the exmaple code above you would have to scan the dynaset, and test individual records. There is no scan function in Access, as there is in xBase, so you must use something like: set d_set = thedb.createdynaset("SQL") if d_set.recordcount<>0 then do while not d_set.eof ... ... d_set.movenext loop endif If you aren't sure how to code the example you gave using this technique just let me know and I am sure I can point you in the right direction. David Adams, Data Strike Computers Ltd. ========================================================================= Date: Mon, 22 Mar 1993 22:19:54 GMT Reply-To: dadams@dstrike.demon.co.uk Sender: "Microsoft Access Database Discussion List" From: David Adams Subject: Re: re: create table and standards etc In message <9303221427.aa04025@demon.demon.co.uk> you write: > > Because MSAccess has deliberatly changed the meaning > behind some of the relational terminologies (in order to comply with > dbase) so it means that it is harder for relationally experienced > users to use it. But I would guess there are more people who have an xBase background who are starting to use Access than people from other backgrounds, such as those with a more rigorous SQL implementation (like DB2 or whatever). Also, see my other reply regarding standards. David Adams, Data Strike Computers Ltd. ========================================================================= Date: Mon, 22 Mar 1993 22:31:10 GMT Reply-To: dadams@dstrike.demon.co.uk Sender: "Microsoft Access Database Discussion List" From: David Adams Subject: Re: Import/Export Setup Window In message <9303221647.aa06651@demon.demon.co.uk> you write: > > SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB > =============================================================== > Why is that this window does not allow me to switch back to other windows > in the access desktop? Since I can find no way of automatically getting > my 75 columns names into my specification (yes I need them cos I'm importing > from a fixed width file) I had hoped to use copy and paste on each column name > . > > I can see that I should have started from the import spec to create the table > but that does not seem obvious, normally one creates the table first > and then loads in data (which may come from many sources. > My we are at the keyboard a lot aren't we! If you have so many complaints about Access then why are you using it?!!! ;) Seriously though, if you are to make progress with Access you must get out of some old fashioned (and they maybe are just fashions, though I doubt it) ways of thinking. Access is a lot more object oriented than other database systems, and so you should try not to go about things the way you may have done in the past. I found it frustrating at first since I knew how to acheive what I wanted in xBase but couldn't see how it could be done with Access. Forgetting 50% of the things I knew about xBase, a lot of things suddenly dawned on me, and I made much faster progress. If Microsoft had taken the plunge you wouldn't define the tables at all, you'd define the forms and that would build the tables. To avoid using the import specification facility (since it was not flexible enough for my needs) I wrote an import routine which used a table as a rule base for where each field starts and ends, to which table it should be added and what type of data it is. It didn't reference any table or field explicitly, instead implicitily from the rules table, so that I can add new import types without changing the code, only the rules table... It may sound long winded but it only took a couple of hours to put together. David Adams, Data Strike Computers Ltd. ========================================================================= Date: Mon, 22 Mar 1993 22:31:58 GMT Reply-To: dadams@dstrike.demon.co.uk Sender: "Microsoft Access Database Discussion List" From: David Adams Subject: Re: Help on split transactions In message <9303221959.aa09489@demon.demon.co.uk> you write: > > This might not be right band-width to ask the following question, > since I am using Access, I thought I should try to get help from > professional Access users. > > How do I split a transaction? For example, a single payment to a > vendor may consist of cost of the product, applicable sales tax and > the shipping charges. I would like to enter all these under one > data entry form (Checks). I would appreciate any general ideas > or any other suggestions. > > I am a novice programmer,so please do not laugh!!! > > Thanks in advance! > > > Ram Dimba > General Accounting > Stanford University > 857 Serra Street MC 6205 > Stanford, CA 94305 > email : ramd@forsythe.stanford.edu > Can you explain your requirements a bit more. I can't see quite what you are asking. David Adams, Data Strike Computers Ltd. ========================================================================= Date: Mon, 22 Mar 1993 18:25:30 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Nathan Brindle" Subject: Re: Help on split transactions In-Reply-To: Message of Mon, 22 Mar 1993 22:31:58 GMT from I think I see what he wants to do. He wants to show a split transaction on a check (or more likely, a deposit) in the check ledger. Quicken does this by opening a little window that allows you to put in multiple notes and amounts, for instance, if you had 3 checks on a single deposit, the ledger would show the TOTAL deposit and you could open the little window for the DETAILS--how much each check in the deposit was, whom it was from, etc. This sounds like a job for a main form/subform where the subform would be a datasheet view of the details. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Tue, 23 Mar 1993 09:24:36 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Pekka Koskinen CIMO Subject: Multiuser settings I'm setting up an Access database, which up to 3-4 people might use simultaneously (they are using the same form to add records to a same table). Any recommendations on what are the best settings(refersh times etc)? Any hints appreciated! Pekka :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) _/_/_/_/ _/ _/_/ _/_/ _/_/_/_/ "Never try to teach a pig to sing. _/ _/ _/ _/ _/_/ _/ _/ _/ You will only lose your temper, _/ _/ _/ _/ _/ _/ and it frustrates the pig." _/ _/ _/ _/ _/ _/ _/ _/_/_/_/ _/ _/ _/ _/_/_/_/ Pekka Koskinen tel +358-(9)0-7747 7962 fax +358-(9)0-7747 7064 CIMO, P.O. Box 343, 00531 Helsinki, FINLAND ========================================================================= Date: Tue, 23 Mar 1993 01:04:49 -0800 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Mark Plutowksi Subject: Comparisons with Paradox & Foxpro TO THOSE OF YOU WHO HAVE USED PARADOX AND FOXPRO FOR WINDOWS: Hopefully by now many of you have had a chance to evaluate ACCESS. I am about to start an evaluation which will culiminate in a choice between Access, Paradox, and Foxpro. As I understand them so far, each has different strengths, namely: Foxpro: portability (Unix, Mac, PC, NT?) Paradox: speed and programmability Access: slick interface and ease of development I intend to write a single mini application in each of these and compare the results. I want to do one mini-application in depth, because it may be that, while Access is great for doing certain things easily, perhaps it is not much easier than Paradox, say, once you require full flexibility. Anyway, here's what I'd like to evaluate: A. Query, sort, filter, and copy time: 1. 400,000 records with 2 fields and integer key. 2. 10000 records with 128 fields, using a long character key which is a function of 2 or more fields. 3. Finding the unique record in a set optimizing a set of constraints (say, 10000 records). B. Rapid prototyping: time to implement a report or form using query, sort, or filter (i.e., A.1, A.2, and A.3.) C. Programmability: control each gives over formatting of complex forms, reports, and menu control flow. D. Ease of use: look and feel of the resulting apps; importantly, is there a look and feel that is enforced by the package (important if the task is to be split up among programmers who are possibly separated by space or time.) I'd be glad to report my results (don't hold your breath, though, I'll be starting on this in a few weeks, needing to line up the resources and programmers so that we can do all of the comparisons concurrently.) Are there any results, tips, or comments anyone can provide that will make my results easier to obtain, more meaningful, or more focussed? Thanks, = Mark Plutowski ========================================================================= Date: Tue, 23 Mar 1993 07:27:34 CST Reply-To: ardie@ux1.cso.uiuc.edu Sender: "Microsoft Access Database Discussion List" From: "R. D. McClary" Subject: Access unusable I have asked this in 2 different UseNET groups with no solution. I cannot run Access when using W4Wg's. My machine will hang at any time - it could by just after I click the icon, it could be just before I can select a menu, it could be while I'm retrieving a file, etc. The lockup is a total hang. I have no alternative but to power down and re-start (ouch!). My machine is an IBM 55/sx w/4Mb RAM and a 6 Mb perm. swapfile. I run only in 386Enh, and, using emm386.exe /noems, I have most of my drivers loaded high. System resources are generally in the low 80's. The hang happens whether or not I have other utilities going (clock, printman, appbar, wallpaper or none, etc.), and it occurs whether or not I have actually used the network. It occurs even if I have neither accessed a remote, shared device nor shared anything from my system. Strangely enough, other people in my workgroup can access and use the copy on my drive (yes, we each have our own licnese!). Finally, I should say that I replaced the network driver with the one that came with Access. My files were all dated NOV 92. When my colleagues got their copies, their files were dated JAN 93. I re-installed Access using their copies - including an even newer net driver. NO LUCK. Right now, I can only use Access by inserting a clean-boot floppy and re-booting. Does anyone in this group have any ideasd? Thanks. [][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][] /| [] ` o.O ' [] ardie@ux1.cso.uiuc.edu =(___)= [] R. D. McClary U [] Department of Plant Pathology ACK!THPTPHH! [] University of Illinois, Urbana-Champaign [][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][] ========================================================================= Date: Tue, 23 Mar 1993 16:26:48 +0100 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: MARTIN@HSEPM1.HSE.NL Subject: Macro condition problem solved Hey guys and girls! I'm feeling enthousiastic because I solved (with some help) a problem. The problem was the macro condition disn't accept my syntax: DFirst("fieldname",tablename)=[fieldname] Wich it should, according to everybody. The solution came when we realized Access uses the Listseparator you have assigned inside Windows under Configuration settings International. So I had a semicolon (;) there defined as separator. That's why. Another one solved. It seems one doesn't have to program much and most things are possible from within the macro (at least that's what I keep trying). Martin Ederveen. ------------------------------------------------------------------------------- | ing. Martin W. Ederveen | "In the future there will be real | | Hogeschool Eindhoven | thinking machines. | | Rachelsmolen 1 | Yes, but who's thoughts will they | | 5612 MA Eindhoven | be thinking?" | | tel. +31 (40) 605 262 | | | MARTIN@HSEPM1.HSE.NL | Quotation from Dr.Who: The Curse | | SURF017@KUB.NL | of Fenric | ------------------------------------------------------------------------------- ========================================================================= Date: Tue, 23 Mar 1993 12:22:00 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Ray Porrata" Subject: RE: Access unusable Acces come with drivers especially for windows for workgroups. This must be loaded before using access on a workgroup setting. As for windows: Using the reference disk get all the address being used by memory boards(eg: D800-DFFF for token ring cards.) And in the [ENH386] section of you system.ini file insert a line emmexclude=MEMORYRANGE1-MEMORYRANGE2. Ray :-) ---------- From: "R. D. McClary" To: Multiple recipients of list ACCESS-L Subject: Access unusable Date: Tuesday, March 23, 1993 7:27AM I have asked this in 2 different UseNET groups with no solution. I cannot run Access when using W4Wg's. My machine will hang at any time - it could by just after I click the icon, it could be just before I can select a menu, it could be while I'm retrieving a file, etc. The lockup is a total hang. I have no alternative but to power down and re-start (ouch!). My machine is an IBM 55/sx w/4Mb RAM and a 6 Mb perm. swapfile. I run only in 386Enh, and, using emm386.exe /noems, I have most of my drivers loaded high. System resources are generally in the low 80's. The hang happens whether or not I have other utilities going (clock, printman, appbar, wallpaper or none, etc.), and it occurs whether or not I have actually used the network. It occurs even if I have neither accessed a remote, shared device nor shared anything from my system. Strangely enough, other people in my workgroup can access and use the copy on my drive (yes, we each have our own licnese!). Finally, I should say that I replaced the network driver with the one that came with Access. My files were all dated NOV 92. When my colleagues got their copies, their files were dated JAN 93. I re-installed Access using their copies - including an even newer net driver. NO LUCK. Right now, I can only use Access by inserting a clean-boot floppy and re-booting. Does anyone in this group have any ideasd? Thanks. [][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][] /| [] ` o.O ' [] ardie@ux1.cso.uiuc.edu =(___)= [] R. D. McClary U [] Department of Plant Pathology ACK!THPTPHH! [] University of Illinois, Urbana-Champaign [][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][] ========================================================================= Date: Tue, 23 Mar 1993 10:23:00 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "ext6774-Another one of those days..." Subject: Re: Help on split transactions I'm not sure that I understand exactly what it is that you want to do with these transactions. Are you saying that you want to take the info that you enter into the (checks) form and send it to different tables or are you sending the information to different programs such as the Peachtree accounting program? Both scenarios have solutions in Access. Give us some more information and we will try to help you out. And remember, we all started at the begining at some point... ========================================================================= Date: Tue, 23 Mar 1993 16:26:35 -0400 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: EMACLEAN@AC.DAL.CA Subject: simple question re counter I am a complete novice with ACCESS or any other database package. My question is: If I use a data type of "counter" as the primary key in one table, can it be a foreign key in another table. And if this is possible, can this foreign key be repeatable. My problem is that I used counter as the primary key in my "customer" table and as long as I had just one order in my "order" table with the customer ID# (which was the "counter" data type) I was OK. When I tried to enter a new order from the same customer the system refused. Thanks for taking the time to help someone "wet behind the ears" and designing a database for a school project. emaclean@ac.dal.ca ========================================================================= Date: Wed, 24 Mar 1993 13:09:07 GMT Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Anne L Zorner R27.G5/" Subject: thankyou for your replys to my notes SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB =============================================================== I am sorry that I have not changed from my old fashioned view of the world but I am trying! Thats why I am asking the questions. I keep hoping that this new world might enable me to do things faster, without producing applications for things that I would hope the system would do for me. Being based on objects I had hoped that this world would allow me to take an object and take pictures of it in different views, say having a table and creating a default export filter to it with column names in place and sample column numbers for within a fixed text file. Or that because I was in one window that it would not stop me from being able to get access to the main windows point and click options. I beleive in things like orthogonality having to use fast paths strikes me to herralding from the old world. I am driven by my mouse, he is a friendly rodent and I get quite disspaointed when he cant be exercised. Again thanks for all the notes. I probably wont answer them all cos sadly I am still based, in the main, in that old world of mainframe operating office systems. Re the standards issue... I am not the one claiming compatability. Just one requesting it, and wondering whether anyone else cared at all. Anne Thankyou =============================================================== ========================================================================= Date: Wed, 24 Mar 1993 10:35:00 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Vince Scarafino Subject: Re: Comparisons with Paradox & Foxpro In-Reply-To: Message of 23 Mar 93 04:04 EST from "Mark Plutowksi" >Date: 23 March 1993 04:04 est >From: Mark Plutowksi >Subject: Comparisons with Paradox & Foxpro >TO THOSE OF YOU WHO HAVE USED PARADOX AND FOXPRO FOR WINDOWS: > > >Hopefully by now many of you have had a chance to evaluate ACCESS. >I am about to start an evaluation which will culiminate in a choice >between Access, Paradox, and Foxpro. As I understand them >so far, each has different strengths, namely: > >Foxpro: portability (Unix, Mac, PC, NT?) > >Paradox: speed and programmability > >Access: slick interface and ease of development > > >I intend to write a single mini application in each >of these and compare the results. I want to do one >mini-application in depth, because it may be that, >while Access is great for doing certain things easily, >perhaps it is not much easier than Paradox, say, once >you require full flexibility. Anyway, here's what >I'd like to evaluate: > >A. Query, sort, filter, and copy time: > 1. 400,000 records with 2 fields and integer key. > 2. 10000 records with 128 fields, using a long character key > which is a function of 2 or more fields. > 3. Finding the unique record in a set optimizing > a set of constraints (say, 10000 records). > >B. Rapid prototyping: time to implement a report or form > using query, sort, or filter (i.e., A.1, A.2, and A.3.) > >C. Programmability: control each gives over formatting of > complex forms, reports, and menu control flow. > >D. Ease of use: look and feel of the resulting apps; > importantly, is there a look and feel that is enforced > by the package (important if the task is to be split > up among programmers who are possibly separated by > space or time.) > >I'd be glad to report my results (don't hold your breath, though, >I'll be starting on this in a few weeks, needing to line >up the resources and programmers so that we can do all of >the comparisons concurrently.) > >Are there any results, tips, or comments anyone can >provide that will make my results easier to obtain, >more meaningful, or more focussed? > > >Thanks, > >= Mark Plutowski I don't know if my request is within the scope of what you are trying to do. If it isn't please feel free to ignore it. However, one item of interest is the extent to which applications can be incorporated into a truely distributed environment. The ease of these packages working with other relational data base environments, such as Sybase, Ingress, ORACLE, DB2 would help some of us understand the implication of choosing these packages vis-a-vis SQL language interoperability. This might be a lot more work than you bargained for, but you asked! :-) Vince ========================================================================= Date: Tue, 23 Mar 1993 16:06:24 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Toby Rockwell Subject: Access on a Network Maybe I'm missing some important point, but I have not been able to get the answer from the documentation, or from MS support, or from local computer staff. What I want to do is run an ACCESS application as an order entry system for a small company. This will run on 4 PC's each running a (registered) copy of access; but all using a single database so that the customer, order, order-entry-line, (etc.) tables are commonly accessed, updated and used for output. From what I have been able to find out, there would be no problem doing this on a traditional Client/Server net. But this seems like killing a gnat with an elephant gun since it seems that a peer to peer network would more than suffice. HOWEVER, I have received conflicting information as to whether or not such a network (WFWG, LANtastic, or NetWare Lite) can accomplish this. I would love to throw a few more dollars Bill Gates way and solve this with WFWG; but first I would like to know if that would work. Can anyone tell me if it will. Alternatively, what IS the solution. We are not of a size to hire a network guru; and the size of the network and application is teeny by most networking standards. ========================================================================= Date: Wed, 24 Mar 1993 08:19:14 CST Reply-To: ardie@ux1.cso.uiuc.edu Sender: "Microsoft Access Database Discussion List" From: "R. D. McClary" Subject: Success with Access and W4WG's My thanks to those that replied to my inability to use Access while W4WG's was running. I needed to exclude the section of memory used by my network card. I think it works now. [][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][] /| [] ` o.O ' [] ardie@ux1.cso.uiuc.edu =(___)= [] R. D. McClary U [] Department of Plant Pathology ACK!THPTPHH! [] University of Illinois, Urbana-Champaign [][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][] ========================================================================= Date: Wed, 24 Mar 1993 11:38:20 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Jim Renaud Subject: Re: Access on a Network > > Maybe I'm missing some important point, but I have not been able to get > the answer from the documentation, or from MS support, or from local > computer staff. > > What I want to do is run an ACCESS application as an order entry system > for a small company. This will run on 4 PC's each running > a (registered) copy of access; but all using a single database so that > the customer, order, order-entry-line, (etc.) tables are commonly > accessed, updated and used for output. From what I have been able > to find out, there would be no problem doing this on a traditional > Client/Server net. But this seems like killing a gnat > with an elephant gun since it seems that a peer to peer > network would more than suffice. HOWEVER, I have received > conflicting information as to whether or not such a network (WFWG, > LANtastic, or NetWare Lite) can accomplish this. I would love to throw > a few more dollars Bill Gates way and solve this with WFWG; but first I > would like to know if that would work. Can anyone tell me if it will. > > Alternatively, what IS the solution. We are not of a size to hire a > network guru; and the size of the network and application is teeny by > most networking standards. > This is exactly what I'm working on right now. When finished, 5 users will be able to enter orders, write POs, print invoices (my client has multiple types of invoices they need), receive shipments (ordered from POs), and finally ship the end product out (from the sales orders). Right now, I have the sales order (add and search) working. PO system is about 75% done. Invoicing is about 30% done. The rest is still "blue-sky" right now. There is a lot of underlying forms and tables that work too; like Customers, Vendors, Parts, Manufacturers, Employees, etc. Right now I have two computers in a WFWGs network that can create orders and update any other the other stuff I mentioned is complete. So the answer to your question is definitely YES. WFWGs can handle doing what you want. I do it (albeit partially) now. I expect to have most of it finished in a couple of weeks. I have NOT had ANY problems using Access on WFWGs. Just make sure you install the network disk (that comes with Access) before using your system on the WFWG network. Also, my client is very pleased with what I have done with Access so far. The Schedule+, eMail, and Chat systems that come with WFWGs have really excited my client also. Go for It! ----------------------------------------------------------------------- Jim Renaud [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-992-2662 Bldg. M3 Room 235 Fax: 408-773-0833 1230 E. Arques Avenue Email: wiseguy@mcode.amdahl.com Sunnyvale, CA 94088-3470 ========================================================================= Date: Tue, 23 Mar 1993 21:54:13 GMT Reply-To: dadams@dstrike.demon.co.uk Sender: "Microsoft Access Database Discussion List" From: David Adams Subject: Re: Comparisons with Paradox & Foxpro In message <9303230909.aa12679@demon.demon.co.uk> you write: > > TO THOSE OF YOU WHO HAVE USED PARADOX AND FOXPRO FOR WINDOWS: > > > Hopefully by now many of you have had a chance to evaluate ACCESS. > I am about to start an evaluation which will culiminate in a choice > between Access, Paradox, and Foxpro. As I understand them > so far, each has different strengths, namely: > > Foxpro: portability (Unix, Mac, PC, NT?) > > Paradox: speed and programmability > > Access: slick interface and ease of development > With respect, in *my* opinion this is complete bunk. Taking each point you mention in turn... Versions of Fox for Unix and the Mac are way behind the DOS versions at present, though it may be a factor in the future. And what about ODBC allowing cross platform data sharing? Always remember that Microsoft are using FoxPro to get at the substantial xBase database market. In the future, when xBase's popularity falters (as surely it will, have you looked at a Fox for Win application's code for example) then what happens to FoxPro and the development of versions on other platforms? All of the OS's you mention (if you are talking about a PC running Windows) have GUI and are becoming more and more object oriented - xBase is just about the least object oriented thing you could have. Surely it makes sense to use a tool that was designed correctly from that start? Speed and programmability of Paradox may be a more reasonable statement. However, I have yet to seem it out perform FoxPro. It is faster than Access when it comes to queries, but opening a form on the screen takes an hour and a day (on a fast PC). Programmability is most certainly a strong point of Paradox, but again, I have not seen anything *useful* that cannot be done with other packages. Access does have a slick interface but then so does Paradox, and even Fox for Windows screens can look very slick, as long as they weren't written for Fox for DOS. Development is easier in that more is taken care of by the system than in Fox, but not more than in Paradox. Which do I think is best? It depends. See below. > > I intend to write a single mini application in each > of these and compare the results. I want to do one > mini-application in depth, because it may be that, > while Access is great for doing certain things easily, > perhaps it is not much easier than Paradox, say, once > you require full flexibility. Anyway, here's what This is a good way of evaluating the applications. It could be a lengthy process though - don't make the applications too simple else you won't have the full picture. > I'd like to evaluate: > > A. Query, sort, filter, and copy time: > 1. 400,000 records with 2 fields and integer key. > 2. 10000 records with 128 fields, using a long character key > which is a function of 2 or more fields. > 3. Finding the unique record in a set optimizing > a set of constraints (say, 10000 records). This are definite requirements and should be easy enough to test - though see notes below regarding Access's performance. > > B. Rapid prototyping: time to implement a report or form > using query, sort, or filter (i.e., A.1, A.2, and A.3.) Significantly faster in Paradox and Access than Fox I would guess, unless you have a lot of xBase expertise (maybe) again see below. > > C. Programmability: control each gives over formatting of > complex forms, reports, and menu control flow. Access is generally considered to be the least flexible of the three and yet I have just completed an application using it which required a very complex flow between forms, things happening automatically etc. It coped fine. > > D. Ease of use: look and feel of the resulting apps; > importantly, is there a look and feel that is enforced > by the package (important if the task is to be split > up among programmers who are possibly separated by > space or time.) All three tools can build easy to use applications - it is more in the skill of the developer than the package. Paradox would probably provide the most flexibility but do you need it? > > I'd be glad to report my results (don't hold your breath, though, > I'll be starting on this in a few weeks, needing to line > up the resources and programmers so that we can do all of > the comparisons concurrently.) I'd be interested to read them. The choice between Fox and Access. I think that the only reasons in the short term not to choose Access are (a) existing xBase applications (not data) and/or expertise and (b) performance. In the medium and long term I think the performance issue will go away - Access is bound to offer at least the performance of Fox. Think about it - Microsoft has access (no pun intended) to the technology which gives Fox its speed. The only reason these software methods couldn't be employed and benefited from in Access is if the internal data structures of Access were not up to scratch. Would Microsoft really design a database product with data structures poorer than those designed years back (for dBase)? I don't think so. And if Microsoft were really going to propogate the Fox product and evolve it then how come it lacks features such as ODBC? Thus all you are left with is the not insignificant factor of xBase expertise and applications. Still, are you still riding a horse because driving a car is more complicated? Between these two and Paradox is tougher. Try your mini-applications and see what you think. It may come down to a choice between Borland and Microsoft, rather than the products, and where you think they are each taking them in future. I hope this helps. I would be interested to hear what you think of what I have said. David Adams David Adams, Data Strike Computers Ltd. ========================================================================= Date: Wed, 24 Mar 1993 16:26:34 PST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: "Ray Porrata" Subject: RE: Access on a Network This should work without a hitch. The first item is to implement a pc which will act as a server. Using WFWG, this computers resources will have to be shared very well(it may need more memory, HD space, etc.) also in the control panel make sure the resources shared fastest settings are set. Distributing the DB The database should be kept on the server & everyone else pounding it. It shouldn't be too hard to get the rest together. Ray :-) ---------- From: Toby Rockwell To: Multiple recipients of list ACCESS-L Subject: Access on a Network Date: Tuesday, March 23, 1993 4:06PM Maybe I'm missing some important point, but I have not been able to get the answer from the documentation, or from MS support, or from local computer staff. What I want to do is run an ACCESS application as an order entry system for a small company. This will run on 4 PC's each running a (registered) copy of access; but all using a single database so that the customer, order, order-entry-line, (etc.) tables are commonly accessed, updated and used for output. From what I have been able to find out, there would be no problem doing this on a traditional Client/Server net. But this seems like killing a gnat with an elephant gun since it seems that a peer to peer network would more than suffice. HOWEVER, I have received conflicting information as to whether or not such a network (WFWG, LANtastic, or NetWare Lite) can accomplish this. I would love to throw a few more dollars Bill Gates way and solve this with WFWG; but first I would like to know if that would work. Can anyone tell me if it will. Alternatively, what IS the solution. We are not of a size to hire a network guru; and the size of the network and application is teeny by most networking standards. ========================================================================= Date: Wed, 24 Mar 1993 19:42:25 -0800 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Mark Plutowksi Subject: Re: Comparisons with Paradox & Foxpro In response to my post: > TO THOSE OF YOU WHO HAVE USED PARADOX AND FOXPRO FOR WINDOWS: > > > Hopefully by now many of you have had a chance to evaluate ACCESS. > I am about to start an evaluation which will culiminate in a choice > between Access, Paradox, and Foxpro. As I understand them > so far, each has different strengths, namely: > > Foxpro: portability (Unix, Mac, PC, NT?) > > Paradox: speed and programmability > > Access: slick interface and ease of development > David Adams replies: : With respect, in *my* opinion this is complete bunk. Ok, so I stand corrected! Actually, thanks. Scratch FoxPro, after hearing what you've had to say about its ease of development. My business partner was selling me on its speed and portability, but I want to get something out to market THIS year, and don't need xBase compatibility, nor do I really need portability and totally blinding speed this year. By the time I do, something better will probably be here. You brought up another key issue, too, that I forgot about: CONNECTIVITY. Access has it now. I'm not sure how Paradox compares in this respect, so would appreciate comments from PDox users on this. : Access does have a slick interface but then so does Paradox, [...] : Development is easier in that more is taken care of by the system : than in Fox, but not more than in Paradox. If I can build what I want quickly and still have something my customer finds easy to use, that is reasonably responsive (i.e., not SLOW) then why go with Access over Paradox? I'm surprised to hear that PDox takes so long to open a form, though. : In the medium and long term I think the performance issue : will go away - Access is bound to offer at least the performance of Fox. : I hope this helps. I would be interested to hear what you think of what : I have said. : David Adams, Data Strike Computers Ltd. It has helped a lot, thanks. I'll focus on the comparison between PDox and Access, and am interested to test the response w.r.t. forms. I've liked what Borland has done with the compiler gui, and expect them to come on strong with databases mgt systems. = Mark ========================================================================= Date: Thu, 25 Mar 1993 09:04:56 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Jefrem Iwaniw Subject: Access vs. FoxPro for Win Since my copy of Paradox for Windows is still in shrink-wrap on my shelf, I'll have to refrain from commenting on it for now :=). Mark Plutowksi writes: > Ok, so I stand corrected! Actually, thanks. Scratch FoxPro, > after hearing what you've had to say about its ease of development. In many ways, Access *is* much easier to develop on, simply because you can do so much without any programming at all (as has been mentioned many times in this mailing list). For small- to medium- sized applications, Access is clearly the platform of choice. However, once your apps become large and/or specialized enough to require significant amounts of programming, IMHO FoxPro Win becomes the superior platform. The ease of use of their menu-designer and screen designer can be questioned (especially when compared to the tools available for C++, Pascal, and VB), but they work and they work well, and the code they generate is clear and concise. Rather than creating a "form-based" app in Windows, you create a "window-based" app, which by its very nature responds much more quickly than a form since it is using the native OS method of displaying information. Debugging under FoxPro is much easier -- those Access message-boxes that keep appearing one-after-the-other during initial runs can be very frustrating. Of course, we all write bug-free code, but in a large app, we may need to eliminate certain "features" that have mysteriously crept-in. Additionally, seasoned Windows users don't need to learn anything new to use a FoxPro Win app, whereas the default Access behavior is a little odd (of course, this can be altered through careful attention to ease-of-use, CUA-compliance, and the like). Mostly, I just want to encourage those of you considering both platforms to not write-off FoxPro, because in many situations, it is the better choice. BTW, my background is heavily C++, C, Windows, and X/Motif, while my database experience (Clipper, FoxPro, Access, SQL) is relatively recent (last year or so), so I may be biased. Just my HO. -Jefrem Iwaniw Pelican Software Corporation ========================================================================= Date: Thu, 25 Mar 1993 09:18:03 EST Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: Harry E Noel Subject: request for listserv manager I know this is bad form but I have tried to get the listserv to dropp me via mail and it claims not to recognize me. Strange since I originally sent the request in by mail the first time. Anyway, please remove me from the list. Sorry, but I tried... :-) thanks ========================================================================= Date: Thu, 25 Mar 1993 12:01:38 -0500 Reply-To: "Microsoft Access Database Discussion List" Sender: "Microsoft Access Database Discussion List" From: TRANKQ1@PROCON.JHUAPL.EDU Subject: Re: Comparisons with Paradox & Foxpro >Ok, so I stand corrected! Actually, thanks. Scratch FoxPro, >after hearing what you've had to say about its ease of development. >My business partner was selling me on its speed and portability, >but I want to get something out to market THIS year, and don't >need xBase compatibility, nor do I really need portability >and totally blinding speed this year. By the time I do, something >better will probably be here. You brought up another key issue, >too, that I forgot about: CONNECTIVITY. Access has it now. >I'm not sure how Paradox compares in this respect, so would >appreciate comments from PDox users on this. Access doesn't have the promised CONNECTIVITY yet. Microsoft has promised the functional OBDC connectivity for Access by this summer. I don't consider the SQL Server connectivity available with the current Access is valuable. If Microsoft allows Access to connect to major databases like DB2, Sybase, and Oracle, then Access is a real contender. Borland has promised the same thing with its IDAPI (Independent Database API). Borland's IDAPI is supported by IBM, Lotus, Novell?. Borland has stated that IDAPI will also cover Microsoft's ODBC. Borland plans to release IDAPI by the summer. It will be interesting to see how these things delivered and implemented. >If I can build what I want quickly and still >have something my customer finds easy to use, that is reasonably >responsive (i.e., not SLOW) then why go with Access over Paradox? > >I'm surprised to hear that PDox takes so long to open a form, though. It is not quite true that Paradox for Windows (P4W) takes so long to open a form. Borland recommends a system with 386DX-33Mhz and 6MB RAM. At home I installed P4W on my Swan 386DX-33 with 4MB RAM. P4W takes about 10 seconds to come up. Then it takes another 15 seconds to open the first form. After that it works fine because all the needed codes have been loaded in memory. However I would not recommend that you do your development in P4W using my configuration. But the delivered applications can probably run fine on user systems that are similar to mine. About development, I would assume that you can develop better applications with P4W. P4W has a "container" design that is quite interesting. If you understand its use thoroughly you can build efficient applications, because lots of codes are reusable (control objects in a container will inherit codes and variables of its container. A container can be a control object in another container.) If codes and data can be reused and shared, your application's response time should be better. I am trying to develop an expert system using this containership approach and custom methods. I would not try this with Access because Access depends too much on its macro language. I find it is tedious to work with both macro language and Access Basic. With P4W, you only have one language to learn. >It has helped a lot, thanks. I'll focus on the comparison between >PDox and Access, and am interested to test the response w.r.t. forms. >I've liked what Borland has done with the compiler gui, >and expect them to come on strong with databases mgt systems. The GUI interface of P4W is very good. Its database engine is great. Currently P4W doesn't support SQL. SQL support will be provided via IDAPI in this summer. Based on the current database access features of P4W, I would not be concerned about Borland's ability in providing SQL support. I think Borland takes more time to think about the distributed database support. Kha Tran P.S. FYI, Borland has a new deal: you can get both Paradox for Windows and Quatro Pro for Windows for $200. How can they make a living with that deal??? Also, PC Week magazine reports that Paradox for Windows has outsold Access. I hope Borland can quickly enhance P4W to maintain its lead. ========================================================================= Date: Thu, 25 Mar 1993 17:02:02 CST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Brian M. Glasgow" Subject: Re: simple question re counter > Date: Tue, 23 Mar 1993 16:26:35 -0400 > Reply-to: > "Microsoft Access Database Discussion List" > From: EMACLEAN@AC.DAL.CA > Subject: simple question re counter > To: Multiple recipients of list ACCESS-L > I am a complete novice with ACCESS or any other database package. > My question is: > > If I use a data type of "counter" as the primary key in one table, can > it be a foreign key in another table. And if this is possible, can > this foreign key be repeatable. > > My problem is that I used counter as the primary key in my "customer" > table and as long as I had just one order in my "order" table with > the customer ID# (which was the "counter" data type) I was OK. When > I tried to enter a new order from the same customer the system > refused. > > Thanks for taking the time to help someone "wet behind the ears" and > designing a database for a school project. > > emaclean@ac.dal.ca >> Try setting the "RELATIONSHIP" AS A "ONE TO MANY" . THIS WILL ALLOW ENTRIES TO BE LOCKED TO THE CUSTOMER DATABASE WITH MULTIPLE ORDERS PER CUSTOMER ========================================================================= Date: Fri, 26 Mar 1993 11:34:46 GMT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Anne L Zorner R27.G5/" Subject: re: setting a starting value for a counter SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB =============================================================== I remembered that someone wondered whther this could be done, well I just found a file in the access directory called psskb.? and it answers many questions, one of them is How can I change the starting value of a counter field to a number other than 1? - its answer is not easy but shows it can be do ne. Anne Thankyou =============================================================== ========================================================================= Date: Fri, 26 Mar 1993 11:49:53 GMT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Anne L Zorner R27.G5/" Subject: re: my 75 column table SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB =============================================================== For those interested in these things, I managed to create the definition for the imput spec from the catalog data stored in SQL/DS. Sadly I couldnt do it from Access cos I didnt have access to the MS columns or tables tables. I think we will now generate something which will generate an import spec to load into access some of the data that we have in SQL/DS. It seems that we can input data directly into then input spec table. Thanks for the clue. So we now have an input spec for the input spec table! Its not quite what I'd hoped, I had hoped that access would do some of the grind for me. But it is deffinitely feasable. My database is now > 2Mb (2621440bytes) with just this one table. ie >5500 rows in 75 columns. Performance is OK especially as there is no Primary Key on it yet. The load took less than 2minutes. A query to produce a sum grouped against 2 columns takes about 20seconds for all the data. The whole table in SQL/DS is some 89000 rows! I am not sure yet whether I will try and load the whole lot in. Downloading it via send/receive takes a bit too long! and I only have a 30Mb free! ( I think it would need 32Mb) (current system is a viglen 486dx2 66MHz 8Mb RAM) Anne Thankyou =============================================================== ========================================================================= Date: Fri, 26 Mar 1993 10:20:34 PST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: RAM DIMBA Subject: RE: Help on Split Transactions Thanks for the people who replied to my question on "Help on Split Transactions". Thank you again for suggesting to use Main/Subform feature. I changed my database structure and added few more tables to achieve my tasks. I found out that It is easier to do lots of things in ACCESS. I am yet familiarize myself with ACCESS Basic. Thanks. Ram Dimba ramd@forsythe.stanford.edu ========================================================================= Date: Fri, 26 Mar 1993 14:51:57 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Sal Scozzari Subject: Subscription request Hello! I would like to subscribe to your recipient list for your Microsoft Access group. Please send any information I need to receive the posted articles. Thank you kindly! :-) Sal Scozzari -------------------------------------------------------------------- Sal Scozzari, Bag of Mostly Water |Internet: sals@zed.com UI Design, Project Zed |UUCP: ...!uunet!aruba!sals -------------------------------------------------------------------- ========================================================================= Date: Fri, 26 Mar 1993 16:24:01 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Ned Walsh Subject: Unsubscribe I don't recall who the list manager is here, so sorry to send this to everyone...Please unsubscribe me. I probably subscribed when my ID was walsh@cunixa.cc.columbia.edu and now it is walsh@cunixf.cc.columbia.edu, so LISTSERV can't find me. Yours actually, Ned ========================================================================= Date: Fri, 26 Mar 1993 16:43:23 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Subject: administrative note Please don't send unsubscribe notices to the list. A simple REVIEW ACCESS-L command sent to LISTSERV@INDYCMS would reveal that I am the list owner. Administrivia sent to the list is just aggravating to the subscribers and I am perfectly willing to take care of these things. Thanks, Nathan Brindle Listowner -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Fri, 26 Mar 1993 18:30:29 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nick_Francesco.ZIFF-DAVIS%LNGATE@ARNOR.ZIS.ZIFF.COM Subject: Re: setting a starting value for a counter stats access-l loc ========================================================================= Date: Fri, 26 Mar 1993 21:45:01 -0800 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Mark Plutowksi Subject: Re: Subscription request Subscribe by mailing to LISTSERV. This kind of broadcas is bad news for everyone. = Mark ========================================================================= Date: Fri, 26 Mar 1993 21:47:19 -0800 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Mark Plutowksi Subject: Re: Comparisons with Paradox & Foxpro Thanks for the informative reply! = Mark ========================================================================= Date: Sat, 27 Mar 1993 14:02:21 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Ned Walsh Subject: Re: Subscription request In-Reply-To: Your message of Fri, 26 Mar 1993 21:45:01 -0800 I am not trying to subscribe. I am trying to unsubscribe. My ID changed since I subscribed, but Columbia's mail router skillfully reroutes mail addressed to my old address to my new address. When I send an unsubscribe request to the LISTSERV I get a message back saying I am not currently subscribed to ACCESS, as far as it knows, and mentions that perhaps the situation is exactly as I described--I'm subscribed under a previous address that has mail being forwarded to my current address. The only way to to get off the list, then, is via the list administrator's intervention. I do not know who the list administrator is. So I write to the list expecting the list administrator will pick up on the message and see that I get unsubscribed. What else do you expect me to do??????? This sort of message to the list re subscription/unsubscription quirks and problems is perfectly legitimate and occurs all the time on LISTSERV lists. It is your message which is rude, inappropriate, and bad news for everyone. /Ned ========================================================================= Date: Sat, 27 Mar 1993 14:04:03 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Ned Walsh Subject: Re: Subscription request In-Reply-To: Your message of Fri, 26 Mar 1993 21:45:01 -0800 Whoops, that was supposed to go to Mark only, not the whole list. Now THAT was a rude, inappropriate, bad news for everyone sort of message. Mucho mucho mucho apologies to all. Talk about having egg on one's face. Sorry, Ned ========================================================================= Date: Mon, 29 Mar 1993 09:03:05 BST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Anne L Zorner R27.G5/" Subject: re fox, access, P4W and Superbase SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB =============================================================== For information, when I was at one of the PC Database days that were done here in the UK, certain people in Microsoft claimed that eventually Fox Pro and Access would come closer together. With them both having the same database engine. One of the big problems, as I see it, with P4W is that its SQL link (similarly for Superbase) will not be available for its own database, it will only be there to access the bigger database systems. For superbase this access will not (they said) be available through their point and click standard interface, does anyone know the validity if that statement? and what about P4W will that have the same problem? By the way does anyone have any knowledge as what will be the features in the upgrade to Access that is due later this year? Regards Anne Thankyou =============================================================== ========================================================================= Date: Mon, 29 Mar 1993 17:49:30 +0200 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Center for Security Studies, ETH Zuerich, Switzerland" Subject: How do I print on form-style paper? I am trying to build a new database for our addresses with ACCESS. Everything is fine except one problem. I am using an old matrix printer (Brother M-1709) to print on "endless-type" address labels in one row. But every time I try that I get a page break from ACCESS after one (supposed) A4-page. What do I do to get rid of this page break, which throws my endless labels off track? Is this an ACCESS-problem, or a windows-printer-driver problem? If so, how do I set my printer driver to an "infinite" page length? Any advice would be appreciated Thomas Koeppel Zurich Polytech, Switzerland koeppel@sipo.ethz.ch Fax: xx41 1 364 00 69 ========================================================================= Date: Mon, 29 Mar 1993 09:51:33 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Steve Miller Subject: Problem combining text fields I have a problem combining multiple fields into a single text box in a report. I have three fields in a table - Title, First Name and Last Name. All three of these are of the "Text" datatype. I want to combine these fields in a report so that they look like Mr. Joe Walker instead of, Mr. Joe Walker I follow the example in the user's guide and use the following as the source for the text box: ="|[Title]| |[First Name]| |[Last Name]|" When I preview the report, I get "#Error" in the text box. If I change the table so that the "Title" field is renamed to "TTitle" and make the corresponding change in the report, everything works as expected. If I just use [Title] as the source for a text box, everything works fine. Does anybody have any ideas before I try Microsoft customer support? Thanks, Steve PS - I also have a similar problem with a field named City. -- +-------------------------------------------------------+ | Steve Miller PictureTel Corporation | | email: miller@pictel.com One Corporation Way | | phone: (508) 977-8235 Peabody, MA 01960 | +-------------------------------------------------------+ ========================================================================= Date: Mon, 29 Mar 1993 10:15:57 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Ron Todd Subject: Re: Problem combining text fields I have a problem combining multiple fields into a single text box in a report. I have three fields in a table - Title, First Name and Last Name. All three of these are of the "Text" datatype. I want to combine these fields in a report so that they look like Mr. Joe Walker instead of, Mr. Joe Walker I follow the example in the user's guide and use the following as the source for the text box: ="|[Title]| |[First Name]| |[Last Name]|" I had the same problem in composing a part number from "product type" "product number" and "product option" as well as composing "product option" from "option types" and "option number". What I did was use string concatination: the "&" character between components of the string as well as Format$() to convert the numbers to strings. A'la =[Title]&[First Name]&[Last Name] But this will not insert spaces between the components so what you will have to do is add in the literals: =[Title]&" "&[First Name]&" "&[Last Name] For the numbers this is what I ended up with: =[product type]&Format$([product number],"")&[product option] The null string in the Format$() function tells Access to return just the number without formating; drop leading spaces and don't use leading zeros or formating characters such as commas or currency symbols. I have noticed the same error messages in querys involving these fields but have not had any problems with the resulting data, I am even using the "part number" as an index in my table and when there is no option specified, the "product option" component returns a null string. Ron Todd ========================================================================= Date: Mon, 29 Mar 1993 10:38:12 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Steve Miller Subject: Re: Problem combining text fields In-Reply-To: <9303291518.AA15738@gateway.pictel.com>; from "Ron Todd" at Mar 29, 93 10:15 am > > I have a problem combining multiple fields into a single text box > in a report. > > I have three fields in a table - Title, First Name and Last Name. > All three of these are of the "Text" datatype. I want to combine > these fields in a report so that they look like > > Mr. Joe Walker > > instead of, > > Mr. Joe Walker > > I follow the example in the user's guide and use the following as > the source for the text box: > > ="|[Title]| |[First Name]| |[Last Name]|" > > I had the same problem in composing a part number from "product type" > "product number" and "product option" as well as composing "product > option" from "option types" and "option number". What I did was use > string concatination: the "&" character between components of the > string as well as Format$() to convert the numbers to strings. A'la > > =[Title]&[First Name]&[Last Name] > > But this will not insert spaces between the components so what you > will have to do is add in the literals: > > =[Title]&" "&[First Name]&" "&[Last Name] > I should of mentioned that I tried this approach, too. This is the way that is suggested in the online help. It didn't work for me either. Any more ideas? -- Steve Miller x235 ========================================================================= Date: Mon, 29 Mar 1993 10:40:53 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: TRANKQ1@PROCON.JHUAPL.EDU Subject: RE: fox, access, P4W and Superbase >SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB >=============================================================== >For information, when I was at one of the PC Database days that were done >here in the UK, certain people in Microsoft claimed that eventually Fox Pro >and Access would come closer together. With them both having the same >database engine. > >One of the big problems, as I see it, with P4W is that its SQL link (similarl y >for Superbase) will not be available for its own database, it >will only be there to access the bigger database systems. For superbase >this access will not (they said) be available through their point and click >standard interface, does anyone know the validity if that statement? and >what about P4W will that have the same problem? > >By the way does anyone have any knowledge as what will be the features in >the upgrade to Access that is due later this year? > >Regards Anne > >Thankyou >=============================================================== I don't know what SQL link Superbase and P4W will provide. But I would believe that P4W will provide a SQL interface that will work with its database engine and remote database engines. Using the SQL interface, the target database engines should become transparent to your applications. I would not think that a product like P4W would make you put a logic in your applications to determine what database engines are in use and to handle them differently. Borland's IDAPI (Independent Database Application Programming Interface) will handle the hard work for you. I would believe that P4W will provide a SQL support that equals to or exceeds what Access currently provides . Kha Tran End of returned message ========================================================================= Date: Mon, 29 Mar 1993 09:45:22 CST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: randy legeai Subject: Re: How do I print on form-style paper? In-Reply-To: <9303291449.AA47886@rs1.tcs.tulane.edu>; from "Center for Security Studies, ETH Zuerich," at Mar 29, 93 5:49 pm > > I am trying to build a new database for our addresses with ACCESS. Everything > is fine except one problem. I am using an old matrix printer (Brother M-1709) > to print on "endless-type" address labels in one row. But every time I try that > I get a page break from ACCESS after one (supposed) A4-page. What do I do to > get rid of this page break, which throws my endless labels off track? Is this > an ACCESS-problem, or a windows-printer-driver problem? If so, how do I set > my printer driver to an "infinite" page length? I had the identical problem printing single-column labels on my Panasonic printer. I called Microsoft, who dutifully checked it out and told me that it is a function of the Windows printer driver, mainly that it only "knows" the predetermined page sizes, and otherwize had no work-around. I did, however, succeed in getting it to work, except that it soes not print the last label on the page. In Print Setup, I set page size to 8.5 x 11. Left and Top Margins to 0.25", (others to 0"), Items Across to 1, Row Spacing to 0.06", Width to 3.5, Height to 0.94. This is for Avery #4145 type labels, that are 12 labels to a 'sheet', with each label 3.5" x 15/16". Let me know if it works! If so, one of us should post the solution to the list. -- Randall Legeai rlegeai@rs1.tcs.tulane.edu Federal Agency Affairs / Ctr. Bioenv. Research Phn: 504/865-5758 327 Gibson Hall, Tulane University Fax: 504/865-5274 New Orleans, Louisiana 70118-5698 ========================================================================= Date: Mon, 29 Mar 1993 12:20:37 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Toby Rockwell Subject: RE: Problem combining text fields To neatly print names my method has been to create a name in the query that underlies the reprort. this will read: name:LTrim([title]&" "&[first name]&" "&[last name]) The Ltrim just assures that things are left justified when there is no title [and first name]. There is still an extra space if there is a title without first name but I didn't bother putting in the extra level of LTrim to cure it since it seldom occurs. With a comma thrown in after the state, this works for the address as well. ========================================================================= Date: Mon, 29 Mar 1993 19:53:36 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Steve Miller Subject: Problem combining text fields (Solution) You will recall that I sent a message asking about the following problem. > > I have a problem combining multiple fields into a single text box > in a report. > > I have three fields in a table - Title, First Name and Last Name. > All three of these are of the "Text" datatype. I want to combine > these fields in a report so that they look like > > Mr. Joe Walker > > instead of, > > Mr. Joe Walker > > I follow the example in the user's guide and use the following as > the source for the text box: > > ="|[Title]| |[First Name]| |[Last Name]|" > > When I preview the report, I get "#Error" in the text box. If I > change the table so that the "Title" field is renamed to "TTitle" > and make the corresponding change in the report, everything works > as expected. If I just use [Title] as the source for a text box, > everything works fine. > > Does anybody have any ideas before I try Microsoft customer > support? > > Thanks, > Steve > > PS - I also have a similar problem with a field named City. > After poking around in the Access Support forum on CompuServe, I found the answer to my question. I quote directly (without permission): You might have a text box called: [CityStateZip] and its source could be the expression: =[City] & ", " & [State] & " " & [Zipcode] Note that you CANNOT use one of the elements in the expression as the NAME of the text box. You could not name the above text box [City] for example, or you would get the #Error indication. Or in my case, I tried to combine a field named [Title] in a text box named "Title". I simply renamed the text box to "FullName". -- +-------------------------------------------------------+ | Steve Miller PictureTel Corporation | | email: miller@pictel.com One Corporation Way | | phone: (508) 977-8235 Peabody, MA 01960 | +-------------------------------------------------------+ ========================================================================= Date: Mon, 29 Mar 1993 20:13:58 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: George Raudabaugh Subject: Mouse Dies I've started banging on Access again and have run into a few problems, most notably the mouse becoming disabled. I haven't figured out when/why this happens yet, but its happened many times (>3), and I was only in the Table area. The "workaround" is to make sure I have a DOS session I can ALT-TAB to and reactivate the mouse driver. This is a microsoft mouse. I haven't seen anything here. I also received an offer package for an Access specific magazine that included a diskette. It include a list of known-bugs but there was nothing about mice. Any info would be appreciated. George -- George Raudabaugh Manager/Document Technologies Information Dimensions, Inc. raudabaugh@idicl1.idi.battelle.org (work email) 5080 Tuttle Crossing Blvd. Dublin, Ohio 43017 (614) 761-7309 (voice mail) ========================================================================= Date: Tue, 30 Mar 1993 10:34:44 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Pekka Koskinen CIMO >I haven't seen anything here. I also received an offer package for an >Access specific magazine that included a diskette. It include a list >of known-bugs but there was nothing about mice. > Any way to get a copy of that list? G'day Pekka :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) _/_/_/_/ _/ _/_/ _/_/ _/_/_/_/ "How many system administrators does _/ _/ _/ _/ _/_/ _/ _/ _/ it take to change a light bulb? _/ _/ _/ _/ _/ _/ None -- they just remove the rights _/ _/ _/ _/ _/ _/ _/ for people to enter the room." _/_/_/_/ _/ _/ _/ _/_/_/_/ Pekka Koskinen tel +358-(9)0-7747 7962 fax +358-(9)0-7747 7064 CIMO, P.O. Box 343, 00531 Helsinki, FINLAND ========================================================================= Date: Tue, 30 Mar 1993 13:21:33 +0200 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Beat Jaccottet Subject: ODBC and access to Sybase on a RS/6000 Hi! I am trying to connect to a Sybase SQL Server (version 4.2) on a RS/6000. I ran the scriptfile (INSTCAT.SQL) for defining the required stored procedures on the DB, I also tested those SP on the DB, they work fine. Also the connection from within windows to the Sybase DB works fine (I have a tool that checks the connection). When I am trying to reference or include a Sybase Table from within Access I get a "general protection violation in USER.EXE at 0010:0470" and Access is gone. Has anyone made similar experiences? Has anyone solved the problem? Any suggestions or recommandations are greatly appreciated. Thanks in advance! - Beat Jaccottet (yes: Beat is my first name...) ========================================================================= Date: Tue, 30 Mar 1993 08:16:54 CST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: randy legeai Subject: Re: Mouse Dies In-Reply-To: <9303300203.AA45880@rs1.tcs.tulane.edu>; from "George Raudabaugh" at Mar 29, 93 8:13 pm > > I've started banging on Access again and have run into a few problems, > most notably the mouse becoming disabled. I haven't figured out when/why > this happens yet, but its happened many times (>3), and I was only in the > Table area. > > I haven't seen anything here. I also received an offer package for an > Access specific magazine that included a diskette. It include a list > of known-bugs but there was nothing about mice. You can download the bug list (and other things) from Microsoft's download BBS at 206/936-6735. -- Randall Legeai rlegeai@rs1.tcs.tulane.edu Federal Agency Affairs / Ctr. Bioenv. Research Phn: 504/865-5758 327 Gibson Hall, Tulane University Fax: 504/865-5274 New Orleans, Louisiana 70118-5698 ========================================================================= Date: Tue, 30 Mar 1993 09:24:00 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Michael Gordon Subject: Re: Mouse Dies >> I haven't seen anything here. I also received an offer package for an >> Access specific magazine that included a diskette. It include a list >> of known-bugs but there was nothing about mice. > >You can download the bug list (and other things) from Microsoft's >download BBS at 206/936-6735. > The bug list is also available somewhere at CICA. Michael D. Gordon CIS: 71053,471 Internet: gordonM@cc.denison.edu Date sent: 30-MAR-1993 09:24:07 ========================================================================= Date: Tue, 30 Mar 1993 17:06:50 MET-1 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Hr. Johannes KREMSNER" Subject: DB2 with ACCESS Has anyone an ODBC-driver for DB2 on an IBM-Mainframe? Special thank's to all who help me with my urgent problem! +--------------------------------------------------------------------+ |University of Art | | |Mr. Johannes Kremsner| | |Networkadministrator | | |Hauptplatz 8 | | |4020 LINZ/AUSTRIA | | +--------------------------------------------------------------------+ ========================================================================= Date: Tue, 30 Mar 1993 12:36:30 -0800 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Dmitry Serebrennikov Subject: General Protection Fault in Access I came a cross a nasty one! Although I didn't isolate the problem completely I suspect it has to do with the following setup: I am using a query to pick records in a specific date interval and a status interval (integers 1...5) from a table of apox 7200 records. The SQL statment WHERE clause includes a construct of type (cond1 AND ((cond2 AND cond3) OR cond4)). Everything works fine until I try to use format() function to format one of the fields (the date). If I add Date: Format(date, "dd-mmm-yy") in the date cell of the query and run it I get a nasty dialog box: "MSACCESS: Your application had internal error! " No metter what button I choose ProgMan kicks in with "General Protection Fault" and throughs me out of Access with half (!) of system memory still taken! This happens consistently and with both format() and format$(). I found a work around, but if you've seen something of the same it would be interesting to find where exactly this thing bombs. Plus I heard that MicroSoft might be reading this.... ========================================================================= Date: Tue, 30 Mar 1993 16:00:00 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: BUCHANANL@NYUACF.BITNET Subject: numerical string field format After years of being relatively adept with dBASE I am slowly learning Access, generally without problem. However, I have been stuck for the last week on this and I am running out of time. I have been unable to figure out what to do by RTM or Cue Cards, etc. I hope someone out there can point me in the right direction. Thanks in advance to anyone who responds! This probably has an outrageously simple answer, but here goes. I want set the format for a field to have numeric content *ONLY* - no alphabetical or other characters - *AND* to be of a specified length; i.e., I need fields that are strings composed of 5 or 10 numerical digits. The fields are not to represent logical numbers but act instead as identifiying code. I don t quite seem to be able to specify this in the Design View box. Any ideas? Thanks! Laurin M. Buchanan Institute of Fine Arts New York University bitnet: buchananl@nyuacf voice: 212.758.3223 fax: 212.755.5780 ========================================================================= Date: Tue, 30 Mar 1993 16:06:17 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Subject: Re: numerical string field format In-Reply-To: Message of Tue, 30 Mar 1993 16:00:00 EDT from There isn't a formatting character for a Text field that allows only numeric input (HELLO MICROSOFT--THIS WOULD BE HANDY). What it looks like you'll have to do is write a validation function that is called every time the field is updated, which checks the string entered to see if each character is a digit 0-9. I just checked the online help under FORMAT PROPERTY and found that you can do what you want to do in a field, but not with a field. I have had some luck with using formats like "93-0000" in counter fields, which gives me numbers I can use like 93-0001, 93-0002 for request numbers, etc. Not knowing the design of your database, that be one way to do it. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Tue, 30 Mar 1993 17:37:24 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: FUNG@ATMOS.NRL.NAVY.MIL Subject: transfer Excel notes to Access When importing Excel *.xls files to Access, is it possible to transfer the Excel note information to Access ? Tak Fung ========================================================================= Date: Tue, 30 Mar 1993 17:37:50 PST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "ROBERT GRINNELL, SEATTLE PACIFIC UNIVERSITY" Subject: RE: transfer Excel notes to Access On Tues, March 30, Tak Fung writes: >When importing Excel *.xls files to Access, is it possible to transfer the >Excel note information to Access ? Tak Fung I am not certain, but I don't think it can do so. It would be difficult to have programmed Access to deal with the potential ambiguities in doing this (notes in different cells of the same row/record, etc.). As a workaround, I would suggest writing a macro in Excel that moves through all cells containing notes and copies the contents to a new column/field, which could then be included in the Access import of the worksheet. There are a couple of limitations inherent in this approach, however: 1. Text in cells is limited to 255 characters; notes can be much longer, so you would lose anything beyond the first 255. 2. If you have multiple notes in a row/record, this must be dealt with somehow. There are several possible solutions, which I won't take the time to go into now. There is another (Excel) macro solution that overcomes these limitations, relying on Access' relational capabilities, but is more complex, because it involves writing the notes to a delimited text file and importing it into Access separately. If you want more detailed thoughts, or aren't up to writing such a macro, feel free to contact me directly. It's an interesting problem, and I could give it a try. Robert Grinnell Seattle Pacific University r_grinnell@luke.spu.edu ========================================================================= Date: Tue, 30 Mar 1993 21:56:16 -0800 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Dmitry Serebrennikov Subject: Re: numerical string field format In-Reply-To: <9303302102.AA12616@nettlerash.berkeley.edu> from "BUCHANANL%NYUACF.BITNET@cmsa.Berkeley.EDU" at Mar 30, 93 04:00:00 pm > > This probably has an outrageously simple answer, but here goes. > I want set the format for a field to have numeric content *ONLY* > - no alphabetical or other characters - *AND* to be of a > specified length; i.e., I need fields that are strings composed > of 5 or 10 numerical digits. The fields are not to represent > logical numbers but act instead as identifiying code. I don t > quite seem to be able to specify this in the Design View box. Any > ideas? > Depending on how (and when) you want the system to complain if someone violates this validation rule there is a simple and a more complicated answer. A simple: you can set validation property in the table or the form to: Like "#########" where every # represents a digit. In case Access considers +-a...f as digits (I dought it) you can do Like "[0-9][0-9][0-9]..." where every [0-9] stands for a character between 0 and 9. In this setup you will get a complaint (contents of the Validation Text propery) when trying to save the invalid value to the table or when leaving a control on the form. A complicated way: someone had suggested it already: attach a function to beforeUpdate propery of the control and check every character as it is typed in. This way you can beep at the user as soon as s/he makes a mistake. Hope this helps. The good place to check is: Access User's Guide p641-656 ========================================================================= Date: Wed, 31 Mar 1993 14:55:20 CST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Brian M. Glasgow" Subject: Re: administrative note > Date: Fri, 26 Mar 1993 16:43:23 EST > Reply-to: Microsoft Access Database Discussion List > > From: Nathan Brindle > Subject: administrative note > To: Multiple recipients of list ACCESS-L > Please don't send unsubscribe notices to the list. A simple REVIEW > ACCESS-L command sent to LISTSERV@INDYCMS would reveal that I am the > list owner. Administrivia sent to the list is just aggravating to > the subscribers and I am perfectly willing to take care of these things. > > Thanks, > Nathan Brindle > Listowner > ------------------------------------------------------------------------------ >>> You failed to mention how one is SUPPOSED to subscribe/unsub. ========================================================================= Date: Wed, 31 Mar 1993 16:11:05 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Subject: Re: administrative note In-Reply-To: Message of Wed, 31 Mar 1993 14:55:20 CST from The reason I did not mention how to unsubscribe is because the information is contained in the "boilerplate" message that is sent to you by LISTSERV when you subscribe. However, for those who don't read such things, UNSUB ACCESS-L sent to LISTSERV@INDYCMS.BITNET will unsubscribe you. If you send the command INFO REFCARD to LISTSERV@INDYCMS.BITNET, the listserver will send back a "reference card" of LISTSERV commands. Nathan Brindle Listowner -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU or NBRINDLE@INDYVAX.IUPUI.EDU ------------------------------------------------------------------------------ ========================================================================= Date: Wed, 31 Mar 1993 21:02:42 GMT Reply-To: dadams@dstrike.demon.co.uk Sender: Microsoft Access Database Discussion List From: David Adams Subject: Re: numerical string field format > > > > This probably has an outrageously simple answer, but here goes. > > I want set the format for a field to have numeric content *ONLY* > > - no alphabetical or other characters - *AND* to be of a > > specified length; i.e., I need fields that are strings composed > > of 5 or 10 numerical digits. The fields are not to represent > > logical numbers but act instead as identifiying code. I don t > > quite seem to be able to specify this in the Design View box. Any > > ideas? > > > Depending on how (and when) you want the system to complain if someone > violates this validation rule there is a simple and a more complicated > answer. < stuff removed > > A complicated way: someone had suggested it already: attach a function > to beforeUpdate propery of the control and check every character as > it is typed in. This way you can beep at the user as soon as s/he > makes a mistake. But this won't check each character as it is typed - the beforeUpdate property is used after the user attempts to update the value in the field (by pressing ENTER, or TAB or clicking on another field for example). It certainly could check each digit, but not as it is typed. You could check the number string thus: for i = 1 to len(field_name) if not isnumber(mid$(field_name,i,1)) then msgbox "Digit " & trim$(str$(i)) & " is not a number", 64 exit function endif endfor or somesuch. David Adams, Data Strike Computers Ltd. ========================================================================= Date: Wed, 31 Mar 1993 16:29:22 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jennifer Spielberger Subject: foxbase/pro Hello! I am not a subscriber to this list, so if you have any words of wisdom, please reply directly to me... I'm looking for a list for FoxBase / FoxPro users and developers. Does ayone know if such a list exists? Thanks in advance for any help you can offer!! +------------------------+----------------------------+---------------------+ | Jennifer Spielberger | jspielbe@wheatonma.edu | (508)285-7722 x478 | | Information Analyst +--------------------------------------------------+ | Wheaton College | "See here how everything leads up to this day | | East Main Street | And its just like any other day that's | | Norton, MA 02766 | Ever been." Jerry | +------------------------+-------------------------------------------------- +